Thread
:
Deleting a group of rows
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Deleting a group of rows
do you mean this?
Sub delrows()
Rows("17:19").Delete
'or
'Rows(17).Resize(3).Delete
End Sub
--
Don Guillett
SalesAid Software
"Dan" wrote in message
...
Is it possible to use the Rows property to delete a range of rows in one
statement in a macro, or must I use a loop and .Rows(I).Delete for each
row
one at a time?
Dan
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett