VBA Arrays Explained in 3 Minutes

👉 Ready to master VBA?
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

VBA Arrays in 3 Minutes

This video provides a complete explanation of arrays in VBA. It covers, using dim and redim to declare the array.
using erase to delete items or the array, copying from a worksheet range to an array, array functions such as
split, join, filter,lbound and ubound etc.

#vbaarray #excelvbaarray #vbarray

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

[Excelmacromastery]

Make sure to download the complete source code for arrays in the description.

[TheChandra]

He is one of the best VBA instructors I have ever encountered on the net.

[DavidRymell]

Thank you, Paul. Although I work with VBA daily (I'm at a stage where it flows from my fingers and I rarely have to google anything). But I STILL find your videos insightful and interesting! Thank you for making and sharing them

[Cc-vumr]

I've been having a lot of troubles finding how to use arrays in VBA. I had errors and the syntax I found dind't work. But this video helped me a lot. I wish I found it sooner, thank you man

[free]

Amazing overview of one of the basic elements that make up VBA. I did not know about half of the items covered here. Thank you so much for this great video!

[bredmond]

Ever since I have started watching your video, I have been trying to implement what you have taught me. I have struggled a bit with the arrays and learned a lot, but I think with this new video, I understand arrays much better and I can get "arrays" at work.

[johnwayne]

Clean instruction for newbes! Great job Paul!👍👍👍😉🤟😎

[johnbutler]

Perfect resource to help with arrays when coding, broad, concise & detailed. (Tho would recommend several of the previous videos if you’ve never used an array before)

[two_stones]

Amazing lecture in under 4 minutes. Thank you.

[jenshaglof]

Thank you thank you thank you! Didn't know the Join command. No more For loops to put the array back together again after a split! This will make my code so much cleaner! :)

[kingpin]

At 0:22 be sure NOT to loop through ranges with this code: range("A" & i)
This causes VBA to create strings at runtime and joining them together, which costs memory and slows down your code.
Rather you should use: range("A1"). offset(i)

[nadermounir]

Thank u Paul for this video i would be great if u could show us more examples in your Upcoming videos

[anssimakela]

I'm an arborist and I like yours VBA content 😄

[joedough]

Thank you Paul. I have an Excel Table and I want to show or hide columns in the table dependent on the value in Column 1 in the selected row. This is dreadfully slow in operation - could this be made more efficient using arrays? Thanks

[TheManiek]

Thank you for the video.
I still have a question, how can I import and save data to listbox from an external .csv file?

[ahmedfreelancer]

Hallo
You are incredible ❤️ person
I want to ask you if I have serach with multiple criteria is possible arrays help me .
I think if i fill one dim array with 2dim array or make multiple dim array will help but i don't know how.

[CollDott]

I thought this is in response to my prior question whether array is case sensitive in comparison! 😆 But it seemed that wasn't mentioned here also!

[nirjasharma]

I have a few questions. how can I reach you.

[hammeedabdo.]

Thank you Mr. Paul,

1- Can the Excel add-in be programmed in another programming language such as C#, C ++, Python or only through VBA?

2- Can we replace VBA in Excel with C#? If it is impossible, why not?

[speedymccreedy]

Never understood arrays before watching this video, still don’t understand them afterwards.