how do I insert the address of a selected cell into a fixed cell

C

cox

Any time I click mouse on a cell, the address of cell is needed to appear on
a fixed cell say a1. In other words if I click the mouse on cell b5 say, the
content of the cell should be "b5". How do I do this?
 
B

bgeier

This should do it for you

Code:
--------------------

Private Sub Worksheet_selectionChange(ByVal Target As Range)
Application.Volatile
Cells(1, 1) = Target.AddressLocal
End Sub
 
Top