Resize dictionary

Hi,

I have an issue with a dictionary which stores a custom object that is not updating as I thought it would. I have set up the following:
- a first loop that goes through the keys and pastes the key/value to a worksheet
- a variable that stores the key name
- remove the key/value from the dictionary
- a second loop that compares the variable to the keys adds the value to the same worksheet
- remove when the keys that were similar to the variable

The specific issue then is that when I remove the Key/Item in the second loop, the first loop is still iterating through them. Is there a way I can update/resize the dictionary in the second loop ?

Here's the (messy) code:

Please Login or Register  to view this content.

Thanks,
amphi

Issue was due to autovivification, by trying to access an non-existing key in a dictionary, VBA will automatically create a blank item.
Probably not the most elegant but added this to my code before the first loop to skip to the next iteration if the dictionary had a blank key :

Please Login or Register  to view this content.

my head hurts now
Found solution here: http://stackoverflow.com/questions/6910996/scripting-dictionary-lookup-add-if-not-present-with-only-one-key-search