To copy to the clipboard........

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


Gord

On 20 Mar 2007 01:48:51 -0700, wrote:

On 20 mar, 01:36, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
"Copying a value without doing something with it
throws an error in this code."

Thanks very much for your clarification.

as was stated i have tried the macro but nothing has been happened
with this macro except the double click function.

would you help me please to get another code that can copy a value
from cell into clipboard either by one or double click.

Thanks in advance.

Lassaad