Macro - Select cell with no text

  • Thread starter Dileep Chandran
  • Start date
D

Dileep Chandran

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
 
L

Lori

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.
 
B

Bernie Deitrick

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
 
Top