Quote:
Originally Posted by Darren
I want to reference a cell no matter what happens to it.
Simple example:
From A1 down:
A1=B1
A2=B2
A3=B3
From B1 down:
5
10
15
If I cut and insert B3(15) into B2, the A column would then read as:
A1=B1
A2=B3
A3=B2
How do I keep the A column referencing the original cell?
|
if you are familar with VBA code, you can also try range.value property it always refers to constanst cell
example below
Dim a As Variant
a = ActiveWorkbook.Sheets("sheet1").Range("A1").Value
ActiveWorkbook.Sheets("sheet2").Range("A1").Value = a
sheet2!A1 always refers to sheet1!A1
all the best