Thanks Jake,
Final syntax that works after trial and error looks like this:
With worksheets
..Range(("A1"),.Range("A1").Offset(0,colTOright)). Select
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