Excel VBA Introduction Part 25 - Arrays

By Andrew Gould

[thomaswashington]

For Efficient Reference:
What You'll Learn 00:11
What is an Array? 00:42
Declaring a Fixed Size Array 01:30
Using the Option Base Statement 02:24
Declaring the Lower and Upper Bounds 03:11
Populating an Array 04:07
Reading from an Array 04:56
Erasing an Array 05:38
Looping Over an Array 07:02
The LBound and UBound Functions 11:10
Declaring Multi-Dimension Arrays 13:02
Populating a Multi-Dimension Array 15:49
Looping Over Multi-Dimension Arrays 18:31
LBound, UBound and Multi-Dimensions 22:13
Reading from Muti-Dimension Arrays 24:57
Dynamic Arrays and ReDim 26:59
Writing a Range to a Dynamic Array 31:44
Erasing Dynamic Arrays 34:16
Writing a Dynamic Array to a Range 35:25
Preforming Calculations in Arrays 38:24
Outputting Answers in New Range of Cells 45:39
Resizing Arrays Dynamically 47:25
LCase Function 49:26
Preserving the Content of Array (ReDim Preserve) 54:20
Transposing an Array (application.transpose) 57:31

[geronimox]

Wise Owl for President! I can’t believe the teaching quality and methodological rigor of this series. Every chapter is a winner. One of my absolute favorite goto VBA sources. Bravo!

[amoorinet..]

Since I am new to this field, I took a week to understand this lecture. Currently, I am almost certain that I can write a book for this lecture due to the comprehensiveness of this lecture, which explains the array.
Really so so so so thanks

[yandhi]

WiseOwl, you helped teach me how to implement a macro at my work that saved hours of work each month (getting praise from my boss + departments) - thank you for your crystal clear and simple tutorials!!! soo appreciative of your work here

[NF-xjqu]

31:44 is hilarious. COMPLETELY over the top *Tearfully shreds all my notes up to now*

These are amazing videos, you are single handedly doubling my work productivity. If you are ever in Dublin, there is a pint owed. I have never learned so much from a Youtube video

[parkseu]

I have been relying on Youtube when it comes to learning such as programming and high level mathematics. But this is by far the best learning experience that I have encountered so far. Not to mention that this is my very first reply on Youtube. Thanks so much for sharing your expertise with everyone!

[morrighannarayvensong]

You just cleared up something about LBOUND and UBOUND that has plagued me for years. No one else has ever explained it that way. Thank you!

[antommylim]

Thank you so much for all the VBA excel tutorial you've uploaded. Each one of your material is better than any of the paid tutorial in the internet.

[krn]

After watching you run through 12, 000 rows yesterday in a flash using an array, I had to rewatch this one again. Love how quick you can calculate hundreds or thousands of rows in a few seconds compared to an individual for each loop. Thanks Andrew.

[dlseller]

Wow! You know that feeling when you've found the tutorial that you've been looking for?...I just got that feeling. I landed on part 25 because I needed a refresher on arrays. I am now a subscriber and will be working through the entire series. Well done!

[supplychainsys]

Andrew / WiseOwl, your pace and level of explanation is just perfect. I write very large models for supply chain optimization. Speed is everything especially in large models. Using arrays as you explained is key way to make my models run amazingly fast. Thanks a ton.

[krispykatz]

I wonder why would someone dislike an educational video.

Thanks brother, by the way.

[matthewgill]

I love how you talk fast. I can't stand waiting for others to finish their sentences.

[TheDaneDavid]

You sir are a life saver ! I knew what I was doing was possible somehow and you just nudged it home! Very good instructions!
Thank you!

[annaokarmus]

Great tutorial not only for begginers but also for those more advanced in VBA :)!

[endsakurayang]

By far the best VBA tutorial I've ever watched.

[shep]

Your right, my confusion was overlooking the fact that using -1 caused results to be
 Dimension1(0 to12, 0 to 4) instead of Dimension1(1 to 13, 1 to 5).  Thanks again for your powerful and engaging series!

[sinzvi]

i sow all your videos, its my main source for learning, after i search the web many days .

[huberterzengel]

Thank you for explaining the Arrays in relation to the "dimensions" of the Sheets in excel. It is such an elegant way to describe what is happening in the script language. And i have never seen yet a better way to use (and explain) the expressions window.

[DarylTinney]

I have watched many instructional videos on YouTube, and without a doubt, yours are the best.  I can't thank you enough.