Can you tell us what it is you are trying to do? There's little need - if
any - to Select anything in VBA. Generally and usually it's a waste of
resources and only slows your operation down.

--
Regards,
Zack Barresse, aka firefytr



"grievesy" wrote in
message ...

Thanks for your help..
I actually just used the following
Cells(orderlineBox.Value, 2).Activate
Selection.Resize(, 18).Select
Cheers


--
grievesy
------------------------------------------------------------------------
grievesy's Profile:
http://www.excelforum.com/member.php...o&userid=10120
View this thread: http://www.excelforum.com/showthread...hreadid=537011