Try this:

=INDIRECT("Sheet2!A1")

That will *always* refer to Sheet2 A1.

--
Biff
Microsoft Excel MVP


"Ant" wrote in message
...
I am not an advanced user of this product and this question I think has a
simple answer, but all my research does not find a solution.

What I would like to achieve;
I am attempting to get a cell on Sheet 1 to read the contents of a
particular Row/Column cell on Sheet 2 with out it being dependant on the
particular cell.

Discussion;
This might appear simple to some but my ending condition is what defeats
me.
I want the Sheet1 cell to only read from for example Row1/Column1 of
sheet2.
So for example if I insert a column later into the first column location
on
Sheet2 the original cell that was targeted for reading effectively is
moved
to column2. Now under normal formulas the sheet1 cell will follow the
original cell to its new location and will now read from Row1/Column2.

However I actually want the Sheet1 cell to only ever read the contents
from
Row1/Column1 regardless of what formatting or insertions occurs on Sheet2.

This is where my efforts collapse.

I would greatly appreciate if any one has any suggestions on how to
achieve
this. I have an feeling the answer is simple and I am just not seeing it.

Thanks