| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to select noncontiguous rows with For loop
I have the following code:
For i = 13 To (ZeroRow - 7) Step 8 .Rows(i).Select Next .Selection.Delete What I'm trying to do is select ALL rows from 13 to (ZeroRow - 7) THEN delete them all at once. With the code written the way it is only the very last row selected will be deleted. How do I get a "hold the control button and select multiple rows" kind of selection using VBA code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select noncontiguous multiple columns by column number? | Excel Programming | |||
| Noncontiguous rows | Excel Discussion (Misc queries) | |||
| Specifying Range.Select in a loop | Excel Programming | |||
| How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
| How to select columns in loop | Excel Programming | |||
Threaded Mode
