Compile-time error- Wrong Number of Arguments when using isEmpty() on array elements

Hi,

I am extremely confused why the following works in a normal VBA module:

Please Login or Register  to view this content.

But the exact same code does NOT work in a custom VBA Class, which has a Variant array as one of its private fields.

In my custom class, I have (outside of any methods) the following array code:

Please Login or Register  to view this content.

In my class_intialize method, I redim() the array to have 3 elements, as follows:

Please Login or Register  to view this content.

Then, I have a function that calculates the number of elements in the array arr():

Please Login or Register  to view this content.

I cannot compile or run any code because I get a Compile Error: Wrong number of arguments or invalid property assignment. The text isEmpty is highlighted.

I know of no other way of truly counting non-empty array elements. Worksheet function CountA counts all (including empty elements) and Worksheet function Count() does NOT count string elements, which is really unfortunate.

Do I need to change how my custom class initializes the array or something? I have spent hours on this and I am completely out of ideas.
Can anyone offer any advice? Thanks!

Welcome to the forum.

Please can you edit your post and surround your code snippets with code tags? (see my signature to see how).

Once that's done, can you tell us if, in your project containing the custom class, if you go to tools > references, are there any references marked with the prefix "MISSING"?

Do you have a custom function or object called isEmpty in your project?

I think a quick way to test this would be to add a VBA. prefix to your Length method.

Please Login or Register  to view this content.

Glad you got it sorted.... I reckon you should give that custom isEmpty method a different name.