PLEASE HELP!! SELECT A ROW AND HAVE CELLS REFERENCE

[fixemup27]

Is there a way to simply click (or highlight) a cell and have it reference "to" another cell?..I want the value in the cell highglighted (or clicked) to be reflected in some other cell within the same worksheet......Thanks!

 

[goodfellow]

I'm not sure if I follow you, but try this:

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