I have a function which will create arrays from worksheets. I am pushing a few sheets through this function and then I run some code on the array that was built.
Now for the problem. Some sheets are empty so the function doesn't build an array. How do I note this so that the next code called doesn't try to process the array?
I have already tried reworking the function so that it will set the variant array to Empty and then in the 'DoSomethingToArray' code, exit the sub if the input array is Empty. However this doesn't work because I get a "Type Mismatch" error message on the variant = Empty.
Any ideas on how to work around this?