Hi
I Have a sheet called "Main" in Which I use a Doubleclick Private function.
When the user Double clicks on a row, I want excel to take note of the row number that was clicked, then move to a different sheet and copy the row in the new sheet (Called "Data") with the same row number as the Target row that was Double Clicked.
Code
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 4 Then
Sheets("Data").Select
Sheets("Data").Rows(Target).Copy
Sheets("Chart Data").Select
Sheets("Chart Data").Rows("2:2").Paste
End If
End Sub
Display More
I know The (Target).Copy line is incorrect but I dont know what the correction is.