Welcome to the OzGrid Forum!
Dim c As Range
For Each c In Range("D2:F22")
If Not IsNumeric(c) Then c.ClearContents
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 1 users browsing this thread. (0 members and 1 guests)