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

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

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

Thank you, Bernie / Lori. This is great help.

-Dileep Chandran