Add row without increasing range

[canhackit6]

Hi,

I am working with Excel 2003 and want to be able to add a row to the worksheet without increasing a range. So, for instance, I am using the max(row($1:$1000)*($A$1:$A$1000=$A68)) trick to get the last instance that a value occurs in a column. However, whenever I add a row to the column, the range in row becomes 1:1001 and the A1:A1000 stays the same because it is referencing another worksheet. Is there any way to add a row without increasing the range?

Thanks!

[Pepe Le Mokko]

Perhaps

Please Login or Register  to view this content.

[canhackit6]

YES!!! That worked. Thank you so much! I have spent so long trying to figure that out!