L
lassang01
Hello,
Could anybody help to get the code that can copy the value of cell to
clipboard in double click?
I tried this but it copies the cell not the value of cell:
Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
On Error Resume Next
If Target.Value <> "" Then
Target.Copy
End If
Cancel = True
End Sub
Your responses are highly appreciated.
Yours:Lassaad
Could anybody help to get the code that can copy the value of cell to
clipboard in double click?
I tried this but it copies the cell not the value of cell:
Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
On Error Resume Next
If Target.Value <> "" Then
Target.Copy
End If
Cancel = True
End Sub
Your responses are highly appreciated.
Yours:Lassaad