| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping error with dynamic range
I have a dynamic range on my worksheet that expands (or contracts) to include
the data in a column. I have VBA code that utilizes this dynamic range. But if there is no data in the column, the code generates an error ... apparently there is no range object at all in this case. Other than general error trapping methods, is there a more direct way to test whether the dynamic range exists? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error referencing linked dynamic range | Links and Linking in Excel | |||
| Defind Dynamic named Range up to first error | Excel Worksheet Functions | |||
| #value! error trying to create a simple dynamic named range | Excel Discussion (Misc queries) | |||
| error trapping | Excel Programming | |||
| Error trapping | Excel Programming | |||
Threaded Mode
