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?

This should do it for you

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

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

--------------------


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546128

Thanks a lot - appreciate your help


"bgeier" wrote:


This should do it for you

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

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

--------------------


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546128