Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty range?
just as little surprise, method specialcells(xlCellTypeFormulas) had to
return "empty" range since there were no formulas, but instead of having ..cells.count=0, or to skip loop in "for each", it thrown error "no cells in the range" is it expected? i had to handle it with error goto, but would be nice to handle it with count=0 this is excel 2000 vba am i doing wrong, or there is realy no other way than throwing error? thnx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range from Sheet1 into empty range in Sheet2 | Excel Programming | |||
Finding next empty empty cell in a range of columns | Excel Programming | |||
Range empty? | Excel Programming | |||
why is range empty? | Excel Discussion (Misc queries) | |||
why is range empty? | Excel Programming |