If Cell Is Blank, Stop Going Down The Column

mjschukas · Mar 26th 2007

the following macro works great if there is data below cell O4...
but is there isn't any (e.g., at the beginning), then the cursor runs down to 65,536...

?if no data exists, how can i stop at cell O5...

Code

Range("o4").Select
 'Range(Selection, Selection.End(xlDown)).Select
 Selection.End(xlDown).Select
 ActiveCell.Offset(1, 0).Activate

mudraker · Mar 26th 2007

Re: If Cell Is Blank, Stop Going Down The Column

What about looking up from the bottom of the sheet

Code

Cells(Rows.Count, "o").End(xlUp).Offset(1, 0).select

**norie** · Mar 26th 2007

Re: If Cell Is Blank, Stop Going Down The Column

mjschukas

mudraker is right, look up not down.

It might also help if you posted a little more code.

I wouldn't even say what you posted was a 'macro'.:)

If Cell Is Blank, Stop Going Down The Column

Participate now!

Share