| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| link a cell in the 'Master' worksheet list to a 'Detail' worksheet | Excel Programming | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
Linear Mode
