View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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