To get the size of an array in Excel VBA, you can use the UBound and LBound functions.
www.excel-easy.com