linking a fixed cell
 

from one sheet I am linking a cell to another sheet.
e.g. SheetAA cell A1 = SheetBB cell A7
Now I insert a colomn in sheetBB and the content of cell A7 moves to B7, the
content in SheetAA cell A1 automatically links now to SheetBB cell B7,
however I would like it to stay linked to SheetBB cell A7, is this possible?

Thanks
Mas

linking a fixed cell
 

Try this:

=INDIRECT("SheetBB!A7")

--
Biff
Microsoft Excel MVP


"Mas" wrote in message
...
from one sheet I am linking a cell to another sheet.
e.g. SheetAA cell A1 = SheetBB cell A7
Now I insert a colomn in sheetBB and the content of cell A7 moves to B7,
the
content in SheetAA cell A1 automatically links now to SheetBB cell B7,
however I would like it to stay linked to SheetBB cell A7, is this
possible?

Thanks
Mas