Welcome to the OzGrid Forum!
TryVB:Sub DeleteStuff() Dim c As Range For Each c In Range("D2:F22") If Not IsNumeric(c) Then c.ClearContents Next c End Sub
I am trying to see if there can be a marco that will (for example) look in the range of cells d2:f22 and if there is a number in a cell-do nothing but if there is a non-number - clear that cell.
Anyone know how to write this??
thanks for any help
There are currently 2 users browsing this thread. (0 members and 2 guests)