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