Hi!

Try this:

=INDIRECT("Sheet1!A"&ROWS($1:1))

Biff

"cjjoo" wrote in
message ...

If i use the indirect formula, i cant just click and drag for the
different rows i am refering to . Is there a solution to this?


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