Sorted

[Tinus]

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

[pinmaster]

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

HTH
JG

[CLR]

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" <[email protected]> wrote in message
news:[email protected]...
> 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