Thanks for the help guys. Bob's suggestion of changing Target to Activecell
worked perfectly and I am still able to call it from the
Worksheet_BeforeDoubleClick event.
FYI, this sheet was getting copied into a master workbook and I wanted to
reduce the filesize by moving the code in the sheet to a module.

Thanks,
Phil

"Phil Floyd" wrote in message
...
I had the following code in a sheet and it worked fine. I moved it to a
module and now I get object required errors.

If Target.Address = "$A$3" Then
Range("C4") = Range("A3")
End If

I tried: If Target.Address = Sheets("Sheet").Range("$A$3") Then
but that dowsn't work either. How can I do this?

Thanks,
Phil