Thread: If a cell in a worksheet is less than Q...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default 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!


Reply With QuoteReply With Quote