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

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

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

Quibble: this would only work within a particular worksheet, not within
the entire document/workbook. Workbook_SheetSelectionChange would be
more appropriate.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=319888