Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
*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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
*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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
*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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Question - Please help | Excel Discussion (Misc queries) | |||
Easy question | Excel Discussion (Misc queries) | |||
If - easy question | Excel Discussion (Misc queries) | |||
Freqencies over Time, in Columns -- Easy Question | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |