Return an Array from Class Property

[williams485]

Hello All,
I'm in the process of creating a Class (cCampaign) which contains various properties. I've done some simple ones without issue and tested successfully. However, I'm trying to create an additional property that will return an array of Row numbers (generated by searching for the cCampaign object name stored within a Collection Class (called cCampaigns). I've written the code below but it returns a 'Type Mismatch' error. I thought it should be simple to spot but can't see the error in my ways. I would greatly appreciate advice and/or solutions to this problem.
As ever, your patience with my lack of experience is welcomed!

Please Login or Register  to view this content.

In the standard module, my intended code will be something like as follows:

Please Login or Register  to view this content.

[shg]

At a glance, the signature should be

Please Login or Register  to view this content.

[williams485]

Thanks for your reply, "shg" - I am now further with my project, but not much.

I've now changed the class properties slightly so that I can return both the full array of row numbers and individual row numbers from the array. To accomplish this I've created a sub that creates the array and simplified the property procedures (and am hoping this is the way to do it). However, when I now run the code I get runtime 91 error (with block not set) at a point that didn't previously stick. I think the issue could be the method or location of the line that calls the sub but i can't be sure. The following extract is within the cCampaigns class that creates a 'cCampaign':

Please Login or Register  to view this content.

The assignRowNums code sits within the cCampaign class module and is as follows:

Please Login or Register  to view this content.

Any clues/solutions to why this doesn't work will be much appreciated.

[JosephP]

you declare a variable

Please Login or Register  to view this content.

but never initialize it before you try and use it

[williams485]

Thanks JP. It's always the simple things I overlook! This is no longer a problem as I'm using the class slightly differently and no longer need to return the array in it's entirety (only access individual elements one at a time).