If a cell in a worksheet is less than Q...
 

I'm looking for a macro to delete all values in a worksheet less than 10.
Can anybody help me with this?!?! THANKS!

If a cell in a worksheet is less than Q...
 

Hi

This should do it.

Sub Test()
For Each c In Sheets("Sheet1").UsedRange
If c.Value < 10 Then c.ClearContents
Next
End Sub

Regards,

Per

"Aaron" skrev i en meddelelse
...
I'm looking for a macro to delete all values in a worksheet less than 10.
Can anybody help me with this?!?! THANKS!