Thanks Jim for pointing that out. Makes sense!
--
Robert


"Jim Cone" wrote:


I assume Bob is probably with a paying customer, so...

If you are in Column A there is no room to offset 3 columns to the left...
To use F.Offset(0, -3) you must be in column D or higher.

Also, .Range(F.Address) is a perfectly acceptable use
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware





"robs3131"
wrote in message
Hi Bob,

I tried this both ways you listed below and I'm getting "Run-Time error
'1004'" both ways...any thoughts?
--
Robert