AutoFill a cell with a value
 

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

AutoFill a cell with a value
 

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