This will *always* refer to cell B5:

=INDIRECT("B5")

--
Biff
Microsoft Excel MVP


"jj" wrote in message
...
I have an application where I need to update cell B5 in Sheet 1 with a cell
value from a specific cell (C4) on Sheet 2. The issue is that in this
instance, I need to be able to select Row 4 in Sheet 2 and insert a new
row
each month, so that I can record new data in Row 4 for the current month.
I
thought that by making the cell reference in Sheet 1 absoute ($B$5) the
current value in Sheet 2, C4 would always be captured. In fact what
happens
is that when I select Row 4, Sheet 2 and insert a new row, the $B$5,Sheet
1
cell reference changes to $B$6,Sheet 1.

How can I make sure that the cell reference in Sheet 1 remains absolute
with
respect to capturing the value in C4, Sheet 2 when a new line in Sheet 2
is
inserted?

Thanks for any help you can provide.

John