F fixemup27 Joined Mar 28, 2012 Messages 3 Reaction score 0 Apr 11, 2012 #1 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!
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 Joined Jun 12, 2012 Messages 53 Reaction score 0 Jun 12, 2012 #2 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 Click to expand...
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 Click to expand...
