Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty range causes error
greetings! i'm pulling data, in the form of dynamic ranges from other tabs,
into a consolidated sheet. sometimes the ranges are empty, either there is no data or we're waiting for data to be entered, and that seems to be causing a problem. part of macro determines how many rows the range is: range("bloc1").rows.count, so that i know how many rows to drop down when placing blocs of data from subsequent tabs. however, when the range is empty "rows.count" seems to give me an error. any ideas, assistance would be greatly appreciated, thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty cell range and error 91 | Excel Programming | |||
#Empty error | Excel Discussion (Misc queries) | |||
Trapping error from Empty Dynamic Named Range | Excel Programming | |||
Finding next empty empty cell in a range of columns | Excel Programming |