Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(1, 1) = ActiveCell.Value

End Sub


"Mike G - D.C." wrote in message
...
Hello-
Is there anyway to set up a cell to display whatever is within the active
cell? In other words, I'm looking to setup A1 to display data from
whichever
cell is currently active/selected within the document. Is this possible?
Thanks