View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] lassang01@gmail.com is offline
external usenet poster
 
Posts: 8
Default How to run this macro

Hello,

would anybody please tell me steps how to run this macro:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
On Error Resume Next
If Target.Value< "" Then
Target.Value.Copy
End If
Cancel = True
End Sub

and how does it work?

thanks