My spreadsheet does contain several formulas and for example I used row link
to A481. When I wil sorted this spreadsheet the rows 481 has another formula
(e.g. link A140 i.s.o. A481). I try to use $A481 but does not help. Could
someone help me out?

Thanks in advance
Tinus

Hi Tinus........

I'm not sure exactly what you are trying to do, but $A481 only freezes the
column, ......if you want to freeze the ROW, try $A$481....

Vaya con Dios,
Chuck, CABGx3



"Tinus" wrote in message
...
My spreadsheet does contain several formulas and for example I used row
link
to A481. When I wil sorted this spreadsheet the rows 481 has another
formula
(e.g. link A140 i.s.o. A481). I try to use $A481 but does not help. Could
someone help me out?

Thanks in advance
Tinus

Hi
Is this what you're looking for?
=INDIRECT(A481)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476527