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!