Hi,
I would appreciate if you can help on this: I have a Redim Preserve statement in a loop. The array get redimensioned a few times(15-20 times) with no problems, but sometimes, I get the message "object not set to an instance of an object".
It looks like its trying to Redim the array while the previous redim is not finished.. I am fairly confident that this is whats happening as I tried to put a textbox to see the arraysize everytime it changes. By doing that the process had to stop for a second or 2 to display the messagebox..
Result: no errors displayed..
Is there anyway to check the status of the array (If it is locked or if the previous redim is not finished)?
Please Help!
I would appreciate if you can help on this: I have a Redim Preserve statement in a loop. The array get redimensioned a few times(15-20 times) with no problems, but sometimes, I get the message "object not set to an instance of an object".
It looks like its trying to Redim the array while the previous redim is not finished.. I am fairly confident that this is whats happening as I tried to put a textbox to see the arraysize everytime it changes. By doing that the process had to stop for a second or 2 to display the messagebox..
Result: no errors displayed..
Is there anyway to check the status of the array (If it is locked or if the previous redim is not finished)?
Please Help!