Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I ignore value from a workbook that are not in my collection?
Hi,
I have created a collection in VB Excel. My macro is reading a value in one cell (on each row) in a spreadsheet and using the collection, it return a Name. Sometime, the value that the macro took from the spreadsheet is not found in the collection index so I get an error message and the macro stopped. But those missing value are volontary so I would like the macro to ignore those and continue with the rest of the function. Is there a way to do that? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a collection into a new workbook. | Excel Discussion (Misc queries) | |||
adding a VBA name to workbook names collection | Excel Programming | |||
Workbook Collection | Excel Programming | |||
Retrieving the Collection of Ranges in a Workbook | Excel Programming | |||
Retrieving the Collection of Ranges in a Workbook | Excel Programming |