hi @all!

i'm using excel 2003 on win2k.

i'll explain my problem by an example:
- write "1" in cell A1
- write "=A1" in B1
- select A1, "insert cells".
- now "1" can be found at A2

and here's the problem: the formula in B1 now says "=A2". how can i
prevent excel from changing B1 to "=A2"? it should remain at "=A1"

???

i think i can't use the OFFSET-function, because i need to point to a
cell in an other table (=Table2!A1 for example)

thanks in advance!


--
suffix
------------------------------------------------------------------------
suffix's Profile: http://www.excelforum.com/member.php...o&userid=37305
View this thread: http://www.excelforum.com/showthread...hreadid=570156