Love the time delayed excel forum.

--
Regards,
Tom Ogilvy

"roblo" wrote in
message ...

Thanks Jake,

Final syntax that works after trial and error looks like this:

With worksheets
Range(("A1"),.Range("A1").Offset(0,colTOright)).Se lect
End with


Had to specific Row and Column offsets for some reason.


thanks again

Robert


--
roblo
------------------------------------------------------------------------
roblo's Profile:
http://www.excelforum.com/member.php...o&userid=22469
View this thread: http://www.excelforum.com/showthread...hreadid=399231