MACRO ISSUE?

[TMM]

I need help figuring out how to double click a cell and have the value of another cell populate in the double-clicked cell. I have a macro that will do that in one cell but I can't figure out how to get the other cells to do the same. If cell G6 is double-clicked the text in C6 will copy to G6. Each cell will need to do this. If there is a better way please let me know! Thank you so much for your time!

The macro I have is:
Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Range("E3").Value = Range("C3").Value
End Sub

 

[offthelip]

try this:

[/I]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
rowno = Target.Row
Target.Value = Range("C" & rowno).Value
End Sub

[I]

 

[TMM]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) rowno = Target.Row Target.Value = Range("C" & rowno).Value End Sub

Thank you So Much!!! It works wonderfully!!!!