Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
My simple program would make me believe that all rows 1 to 16 will be deleted. Not so. Only the odd numbered entries in col.A got deleted, entries 2,4,6,....16 remained. My simple program is this: ------------------------------------------------------------------------------ Sub deleterows() Dim i As Long For i = 1 To 16 Rows(i).Delete Next i End Sub -------------------------------------------------------------------------------- Thanks for your help. Regards, Gabor Sebo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofil on variable rows, delete extract and show remaining rows | Excel Programming | |||
Delete & Merge Columns,Delete Rows with filter, etc | Excel Programming | |||
Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |