Hi,

I need to automatically fill a cell with a value from another cell once the
other cell is selected.

I have a list of numbers in column F and I need cell H2 to equal which ever
cell is selected or even double clicked (if that's possible).

Is there any way of doing this?

Thanks in advance

Install this event macro:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Target.Column = 6 Then Range("H2") = Target
End Sub

Regards,
Stefi

€žN1KO€� ezt Ã*rta:

Hi,

I need to automatically fill a cell with a value from another cell once the
other cell is selected.

I have a list of numbers in column F and I need cell H2 to equal which ever
cell is selected or even double clicked (if that's possible).

Is there any way of doing this?

Thanks in advance