Hi,

I didn't know how literal you wanted us to take "without recalc" you aren't
recalcing, Excel is, and it isn't recalculating the workbook but just the two
cells where the formulas are.

Put the following formulas in A1:A2 of Sheet1, for example:

=CELL("address")

=MID(CELL("filename",'Moving The Data
Field'!G19),FIND("]",CELL("filename",'Moving The Data
Field'!G19))+1,50)&CELL("address")

Then add the following code to your workbook:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("Sheet1").Range("A1:A2").Calculate
End Sub

If this helps, please click yes

Cheers,
Shane

"haystack" wrote:

How can I get a cell in sheet1 to display the active cell address in sheet1
at all times without having to recalc when the active cell is changed? And
if that is possible, how then can I display in another cell in sheet1 the
address of a cell in sheet2 that corresponds to the active cell in sheet1
without having to recalc when the active cell in sheet1 is changed? Thanks