How big can an array be in VBA?
60 dimensionsKeeping this in view, how big can an array be in Excel?The limit is less than the number of rows by the number of columns in the worksheet which is 1048576 rows by 16384 columns (Excel specifications and limits).Subsequently, question is, what is the maximum size of an array? The maximu...