I have a sheet that the following works great on ...
so on the same worksheet i would like to get the Dble Click to fire a copy and paste (value only) COPY from cells A63:A65 (depending on which cell i dble click) and PASTE to cell F60 on the same sheet... i have the following, no error but it doesn't do anything that i can tell.Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("B33:B44")) Is Nothing Then
Application.EnableEvents = False
If ActiveCell.Value = ChrW(&H2713) Then
ActiveCell.ClearContents
Else
ActiveCell.Value = ChrW(&H2713)
End If
Cancel = True
End If
Application.EnableEvents = True
End Sub
I obviously dont know what i am doing please help...Private Sub Worksheet_BeforeDoubleClick2(ByVal Target As Range, Cancel As Boolean)
If Not Active(Target, ("A63:A65")) Is Nothing Then
Application.EnableEvents = False
If ActiveCell Then
ActiveCell.ClearContents
Else
Selection.Copy
Range("F60").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True
End If
Application.EnableEvents = True
End Sub
Bookmarks