Dileep,

If you are looking for a blank cell at the bottom of column B:

Cells(Rows.Count,2).End(xlUp)(2).Select

If you are looking for a blank cell within cells that may be filled already:

Range("B1").End(xlDown)(2).Select

Note that you never need to select a cell to do something with it...

HTH,
Bernie
MS Excel MVP


"Dileep Chandran" wrote in message
ups.com...
How can I give a code to select a cell in column B with no text?

If cells B1:B100 has text, I have to select B101. Make sense?

-Dileep