| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding a loop to conditional delete code
Hello all,
I have the following code: Sub DelOver16() If ActiveCell.Value = 16 Then ActiveCell.EntireRow.Delete End Sub What I need to do is have the code loop through cells F2:F10000 and delete entire rows that have a value of =16. How would I do that? Many thanks in advance Mark -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200608/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit this macro code to loop and end | Excel Discussion (Misc queries) | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| bar code help, adding asterix to reference | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) | |||
Threaded Mode
