Passing Array of Collections: Object or With Block not Set

[k64]

When trying to pass an array of collections to another sub, I get the error: Object or with block not set. However, if I have already added an item to one of the collections, that collection works, but the other "empty" ones do not. Any idea why?

Please Login or Register  to view this content.

[jindon]

Public variable?

Please Login or Register  to view this content.

[k64]

Is that what's causing the issue? Your code works. I made my variable public because I have some subroutines in UserForms and others in a standard module that I want to use the same list of files for. One sub collects the list of files, another gets all the file sizes, a third sorts it, a fourth calculates checksums, etc. Is there a way to a) make it work with a public variable or b) avoid using a public variable but use the same list of files in all my subs?

[jindon]

No, you are trying to create an instance in Dim statement.
If you want it public, no need to pass the variable to the next sub.

Please Login or Register  to view this content.

[Kyle123]

One sub collects the list of files, another gets all the file sizes, a third sorts it, a fourth calculates checksums,

So pass it as a parameter, your code needs refactoring

[k64]

jindon - Thank you. So, I'm gathering that simply ReDimming it doesn't initialize the member collections or something. It seems like the new keyword might do that. I'm actually not sure exactly what the new keyword does. Can explain it in this context?

Kyle123 - I considered passing it as a parameter, but I don't have a good intuition about when things should be passed as parameters and when to use public variables. Do you have a rule of thumb for this? Also, what is refactoring?