Multi-Dimensional Arrays

**ajocius** · 11-08-2009, 12:06 PM

Does VBA for Excel 2007 have the capability to do large multi-dimension arrays. I'm looking for a 3 dimension 150 row array. Is this possible?

**shg** · 11-08-2009, 02:24 PM

Sure. Arrays can have up to 60 dimensions, with total size limited by memory available to Excel.

**ajocius** · 11-09-2009, 06:24 AM

How would you show a 3 dimension array with 150 elements?

**shg** · 11-09-2009, 11:20 AM

Here's an example:

Please Login or Register  to view this content.

Re: Multi-Dimensional Arrays