Hi
try
range(cells(2,2),cells(ActiveSheet.Cells(Rows.Coun t,
"B").End(xlUp).row,2)).select

though in most cases it is not required to select cells within in
macro



--
Regards
Frank Kabel
Frankfurt, Germany


Rex Dunlap wrote:
The following code gets the last data cell in column B:
Range("b20000").End(xlUp).Select

I would now like to select the Range("Activecell:B2"). How
do I do that?

Thank you for your help.