Fixed Formula
 

When i create a formula from another sheet i can not fixed the link. Examply
the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
column of the A column then the formula gets the new data as "=Sheet2!$B$1"
but i don't want to excel point the new cell, i want it to be fixed at
"=Sheet2!$A$". Any way to solve this problem?

Fixed Formula
 

=INDIRECT("sheet2!A1")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tsunamic" wrote in message ...
| When i create a formula from another sheet i can not fixed the link. Examply
| the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
| column of the A column then the formula gets the new data as "=Sheet2!$B$1"
| but i don't want to excel point the new cell, i want it to be fixed at
| "=Sheet2!$A$". Any way to solve this problem?

Fixed Formula
 

=INDIRECT("sheet2!$A$1")
--
David Biddulph

"Tsunamic" wrote in message
...
When i create a formula from another sheet i can not fixed the link.
Examply
the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
column of the A column then the formula gets the new data as
"=Sheet2!$B$1"
but i don't want to excel point the new cell, i want it to be fixed at
"=Sheet2!$A$". Any way to solve this problem?