Thread: delete rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helene and gabor helene and gabor is offline
external usenet poster
 
Posts: 58
Default delete rows

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