Array resources

The getarray function from the first post in this series, plus functions to transpose, count the number of dimensions, and return other information about arrays, ranges or values:

Chip Pearson’s Functions for VBA Arrays (also have a look at his index page, there is a huge amount of information and downloads on arrays)http://

Alan Beban’s array functions

Colo’s Junk Room VBA tips, starting off with arrays

Microsoft Developer Center on understanding arrays

This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Array resources

  1. jonpeltier says:

    Don’t forget “Using Array Formulas in Excel” by Bob Umlas:


  2. dougaj4 says:

    Thanks Jon. Excellent Link.


  3. Pingback: Daily Download 30: Data Transfer, to and from VBA | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.