How do I efficiently delete many rows from a named range

I load a template file and drop data into named ranges on the template.

Sometimes the data does not require all of the rows in the range. I want to be able to

sheet.Range(row, col, lastrow, last).Delete

but I cant find a way to do this.

To iterate over the list takes to long. I want to be able to delete all of the rows at once.

How do I efficiently delete many rows from a named range

1 Reply

RC Robert Chapman August 2, 2006 07:49 PM UTC


It takes 4 mins to delete 900 rows in a named range


>I load a template file and drop data into named ranges on the template.

Sometimes the data does not require all of the rows in the range. I want to be able to

sheet.Range(row, col, lastrow, last).Delete

but I cant find a way to do this.

To iterate over the list takes to long. I want to be able to delete all of the rows at once.

How do I efficiently delete many rows from a named range

Loader.
Up arrow icon