*Easy* question this time!

  • Thread starter Thread starter aapp81
  • Start date Start date
A

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
 
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
 
Back
Top