So you want to select the range from B3 to the last cell? I think you
can try this syntax.

Range(Cells(3, "B"), Cells.SpecialCells(xlCellTypeLastCell)).Select


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=397766