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