I have an excel spreadsheet which recieves an array of custom objects. I've tried to do something like
where item is declared as an object of the custom typeFor Each item In returnVal msgbox item.someField next item
I get an error message "object required".
How can I get this variant object to act like an array so that I can iterate through it and find the data in all the objects?