How to Create a Static Range when Deleting Rows
Posted by David Holstein on February 20, 2000 4:00 PM
I have a macro that allows me to delete rows by ActiveCell.EntireRow feature. It then recreates my formulas at Row 10 and uses Autofill to copy the formulas to Row 1009 (gives me 1000 rows).
The problem I am having is when I delete the rows, the formulas are never copied down to Row 1009. I have tried Naming the Range F11:Q1009 and using the name as a reference, but when I look at the range properties of the NAME after deleting rows, it is always less then 1009.
Thanks in Advance