I have already created the form and can make the inputs select a cell
but i cannot seem to select a range.
The user enters a row and i want to select that row from column b t
column s.
I am using
Cells(orderlineBox.Value, 2).Activate
to select the row and column 2 (B).
How do i select the range??

Please help.

--
grieves
-----------------------------------------------------------------------
grievesy's Profile: http://www.excelforum.com/member.php...fo&userid=1012
View this thread: http://www.excelforum.com/showthread.php?threadid=53701