From a Data Range DoubleClick on a cell to populate elsewhere
 

I have a large named data range that when one cell is double clicked on that
I would like the value from that cell to populate in a cell on another
worksheet. Is that possible? Thx.

KK

From a Data Range DoubleClick on a cell to populate elsewhere
 

Put the following event macro in the worksheet code area:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Copy Sheets("Sheet2").Range("A1")
Cancel = True
End Sub

It will take any cell double-clicked and copy the contents to Sheet2 cell A1.

Adjust to suit.
--
Gary''s Student - gsnu200851


"KalliKay" wrote:

I have a large named data range that when one cell is double clicked on that
I would like the value from that cell to populate in a cell on another
worksheet. Is that possible? Thx.

KK