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!

[JieJenn]

You might have to rely on VBA for this one. Let me know if you're flexible.

[canhackit6]

I've never used VBA and don't really understand it. Is it simple or would it take some time to learn?

[JieJenn]

Hum..... I think you might have to depend on other experts on this one. My knowledge is very limited when it comes to Excel. I can't think of a solution without using VBA.