To goto the first blank cell in the selected column, enter in the name
box (next to the formula bar) or in the Edit Goto box:

index(c,match(true,isblank(r1c:r65535c),0))

To use in code use application.goto with the above formula enclosed in
quotes.

Dileep Chandran wrote:

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