VBA code to double click and past on three different columns

[Mark1112]

Hi Guys,
I am novice in VBA... this is what I am trying to do:
I have 1.000 raws and four columns, on double click on each cell of the three columns E, F, G it must copy the value from the same raw of column C into the cell where I clicked.
Example: double click on G6 --> copy C6 in G6

I started to write my little VBA code but I don't know the most important command to do this..... (???????????)
(sorry for my english)

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Columns("E5:G1000")) Is Nothing Then
Cancel = True
?????????????????????
End If
End Sub

 

[Fluff]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   If Not Intersect(Target, Range("E5:G1000")) Is Nothing Then
      Cancel = True
      Target.Value = Range("C" & Target.Row).Value
   End If
End Sub

 

[Mark1112]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   If Not Intersect(Target, Range("E5:G1000")) Is Nothing Then
      Cancel = True
      Target.Value = Range("C" & Target.Row).Value
   End If
End Sub

It works perfectly... it is exactly what I need !
Thank you very much, Fluff ?
You are GREAT !

 

[Fluff]

You're welcome & thanks for the feedback.