Display Selection

[Chris.Babbitt]

Hello helpers!

Please could someone tell me how I can get a cell to display the contents of any other cell that I select just using the cursor?

Many thanks
Chris

 

[VoG]

Try like this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Target.Value
End Sub

 

[Chris.Babbitt]

Perfect!
Many thanks
Chris