How do I efficiently delete many rows from a named range

[Robert Chapman]

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

[Robert Chapman]

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