Load active cell data via a function

[Mike G - D.C.]

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]

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

End Sub

 

[hgrove]

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 withi
the entire document/workbook. Workbook_SheetSelectionChange would b
more appropriate