Deleting a group of rows
 

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

Deleting a group of rows
 

Range("M14:O14").EntireColumn.Delete



"Dan" skrev:

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

Deleting a group of rows
 

excelent wrote:
Range("M14:O14").EntireColumn.Delete

or even EntireRow

Deleting a group of rows
 

As a guess you intended rows not columns...

Range("M14:O14").EntireRow.Delete

Deleting is one of those slow things to do in Excel. You are always better
off to create one single large range area and delete it all at once than to
delete a bunch of rows one at a time. The rows do not have to be continuious
either

Range("A1:A5", "A10:A15").entirerow.delete



--
HTH...

Jim Thomlinson


"excelent" wrote:

Range("M14:O14").EntireColumn.Delete



"Dan" skrev:

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

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