Select the last cell?

[Bob]

In my macro how can I select the last cell in B Column that has data in it?
--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Andy Brown]

In my macro how can I select the last cell in B Column that has data in
it?

It depends on your version. Either

Range("B65536").End(xlUp).Select

or

Range("B16384").End(xlUp).Select

http://support.microsoft.com/default.aspx?scid=kb;en-us;148355

Rgds,
Andy

 

[Tom Ogilvy]

cells(rows.count,2).End(xlup).Select

 

[Bob]

BRILLIANT Tom!!!!

--
Thanks in advance for your help....Bob Vance
..
..
..
..