Hi!

Try this:

=INDIRECT("Sheet1!A1")

That will always refer to Sheet1 A1 no matter if you insert rows or delete
rows.

Biff

"cjjoo" wrote in
message ...

hi guys , this is my problem:

i got two worksheets and sheet 1 has got datas and sheet two is exactly
as sheet 1 and the datas are reference to sheet 1.

so in sheet 1 A1, the value is 5

in sheet 2 A1 , the formula used is =sheet1!A1

the formula applies for the column A in sheet 2 .

the problem is : if i delete any rows( shift rows up) in sheet 1 ,
sheet 2 will

return #REF!


Is there any way of preventing that?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=487511