*Easy* question this time!
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

*Easy* question this time!
 

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" wrote in message
...

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

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

BUT, there's one col., col F, where there ARE blank cells but for
the
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 '
in
them... and there are sporadic "blanks" (or " ' ") that don't show
up
in the cell...

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

thanks in advance,


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

*Easy* question this time!
 

hey, thanks a lot, works great

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com