The answer to the first question is to right click the tab at the bottom of
Sheet1 and select View Code from the popup menu that appears, then to
copy/paste the following code into the code window that appeared....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = ActiveCell.Address(0, 0)
End Sub

where I assumed A1 was the cell you wanted to show the active cell's address
in. As for your second question... it doesn't make sense to me. Did you
perhaps mean to say you wanted a cell on Sheet1 to reflect the address of
the active cell on Sheet2 (rather than Sheet1 as you stated)? If so, right
click Sheet2's tab, again pick View Code from the popup menu and then
copy/paste this code into the new code window that appeared...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sheet1").Range("A2").Value = ActiveCell.Address(0, 0)
End Sub

where I assumed A2 was the cell you wanted to show Sheet2's active cell
address.

--
Rick (MVP - Excel)


"haystack" wrote in message
...
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