delete rows
Gabor,
To see why try:
Sub deleterows()
Dim i As Long
For i = 16 To 1 Step -1
Rows(i).Delete
Next i
End Sub
"helene and gabor" wrote in message
...
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
|