Hi Kathy,

It would be helpful to see your code.


---
Regards,
Norman



wrote in message
ups.com...
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,