Hi,
How can I clear collection or all items inside for use it in next loop?
![]()
Please Login or Register to view this content.
Hi,
How can I clear collection or all items inside for use it in next loop?
![]()
Please Login or Register to view this content.
Hi zico8,
try it
![]()
Please Login or Register to view this content.
Hi nilem,
Thanks for replying but it doesn't work.
I get an error: run-time error '457':
This key is already associated with an element of this collection
I think it is still the same collection and I should clear it first. But how?
Did you remember to write this line
Or show please an example of a file in which an error occurs![]()
Please Login or Register to view this content.
Hi nilem,
I have checked my code and realized that I had:
between my loops what caused an error.![]()
Please Login or Register to view this content.
I don't exactly know what is this for but thank you for help.
It's not clear from your code what you are actually trying to do.
Why are you using a collection?
Your code already clears the collection within each interation of k by use of
What is the point of loop k, it does not appear to change anything during the 5 interations.![]()
Please Login or Register to view this content.
An example workbook containing before and after data sets might help explain to us what you are attempting to do
I had a mistake in my sample code above.
It should look like:
but as I written above I had also On Error line between two loops.![]()
Please Login or Register to view this content.
After deleting it everything works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks