如何使用Excel VBA将值推送到非预先指定的数组大小

i'm seeking help to push in value parse from XML based on certain filter/word matching into an arraylist. However, this array should not have a pre-defined array size as the XML inputs are dynamic from file to file. Meaning, XML file1 may have 10 of such inputs and XML File2 may have 15 inputs. Can someone pls advise how i can do below 2things:i'm seeking help to push in value parse from XM