Macro - Select cell with no text
 

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

Macro - Select cell with no text
 

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

Macro - Select cell with no text
 

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

Macro - Select cell with no text
 

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

-Dileep Chandran