I want cell A1 to equal $A$2 even after inserting line at A2

A

adamb2000

Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1'
gives me is that of 'A3'.
I would like 'A1' to equal whatever number inserted into 'A2'.

I am using office excell 2003.
 
R

Ron Coderre

Try this:

A1: =OFFSET(A1,1,0)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Top