*Easy* question this time!

[aapp81]

my last few questions have been a bit odd and difficult to phrase/answe
but this one's pretty easy...

first, i tried this: Selection.SpecialCells(xlCellTypeBlanks).Select t
see exactly where on the sheet it would select blanks... and as
suspected, it selected them where i thought it would...

BUT, there's one col., col F, where there ARE blank cells but for th
life of me i can't seem to be able to "select" them...

col F is Cond. Formatted so any cells that aren't filled have a ' i
them... and there are sporadic "blanks" (or " ' ") that don't show u
in the cell...

all i need is a simple macro similar to
ActiveSheet.Range("F1").End(xlDown).Select that will go to the nex
empty "LOOKING" cell... instead of the end of the data...

thanks in advance

 

[Bernie Deitrick]

As you've found, empty means empty, not empty-looking.

In keeping with your code examples,

Selection.Find("", , xlValues).Select

will find the next empty looking cell.

HTH,
Bernie
MS Excel MVP

 

[aapp81]

hey, thanks a lot, works great