Copying gets cancelled in VBA

[gallen]

I want to be able to double click a cell and have VBA to copy the row of information.

I currently have:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)'code to copy the row of information to the clipboard


    Application.EnableEvents = False
    Dim s As String
    If Target.Value <> "" Then
        s = "B" & Target.Row & ":H" & Target.Row
        Range(s).Copy
    End If
    Application.EnableEvents = True
        
End Sub

If I step through the code, it works fine, but if I do this normally, I can see it copies but then the cursor goes within the cell and the copy seems to be 'cancelled' ie. you can no longer paste.

In essence I want to double click the cell to copy the row then in a different woorkbook, paste the copied cells.

Must be something basic I'm doing wrong. Any clues?

 

[baitmaster]

you are entirely right, it is something basic

The normal action for double-click is to enter the cell. You are using the "before double-click" event to copy the range, before entering the cell

To prevent it you need to make use of that pre-defined variable you can see in your code header. Add

Cancel = True

as your first line of code to cancel the default action

 

[gallen]

ray:You hero .

Cheers. Never paid that any attention. I will in future

 

[baitmaster]

this is my 1261st post, and you're the first person ever that's noticed that I am indeed pretty effing heroic

well done