VBA Array with Filter, Sort and Slice (2021)

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

VBA Array with Filter, Sort and Slice (2021)

The Array is VBA is super fast which is why we use it. But it has limited functionality. In this video I'm going to show you a brand new Array class that allows you to easily sort, filter, search, reverse, retrieve rows and columns and more.

At the end of the video, you will see an amazing FilterBy Function that allows you to create custom filter functions just like you can do in most modern programming languages.

#VBAArray #VBAArrays #ExcelVBAArrays

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

Debugging:
Compile the code: Alt + D + C 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)

Table of Contents:

00:00 - Introduction
00:11 - Why use Arrays?
02:30 - The problem with the standard VBA array
02:43 - Adding the array class to your code
06:26 - Inserting Rows
07:51 - Removing rows
08:32 - Searching the Array using IndexOf
10:35 - Basic Filtering
11:35 - Filter using custom functions
13:49 - Create a compare function easily
14:59 - IndexOf with a custom function

[gertverboomen]

YouTube should add an additional button because a thumbs up is a large understatement for this kind of quality content! Thank you sir, I have learned a lot from your videos, highly appreciated!

[Orumaiti]

There are probably millions of VBA coders struggling with these array manipulations, and you got just what the doctor ordered.
I wish Microsoft would add your classes by default so that all could benefit from your excellent work!

[SimpleExcelVBA]

Wow, I'm impressed by the amount of work You've put in this class and now You're sharing it with others, awesome!

[sumrazz]

I've added dozens of functions over this class for my personal use, such as sumif, getunique....Life has never been easier!!!

[sandeepagarwal]

This is what is - Sharing Wealth...and what can be a greater wealth than knowledge....may be with only exception of 'Health' wealth :) Hats off to you, Paul!

[marcesil]

This wanderfull, Paul! Your videos always teach me a lot. Thank you very much! Greetings from Paraguay.

[tienta]

Verry impressive for the performance. i hope we will have a sort by column in the near future.

[yaoyao]

What an amazing job you have done and provided, highly appreciated !

[joaocustodio]

Paul, absolutely fantastic.
You never ceases to amaze me.
From Portugal, a huge thanks.

[cloudli]

What amazing training!!! Thank you so much!

[Max-vnmu]

De acuerdo con estos comentarios. Lo mejor que he visto en Youtube. Calidad y cantidad. Y eso que no es mi idioma. Pero vale la pena el esfuerzo porque es lo mejor que hay por lejos de VBA en Youtube.
Thank you a lot for your contents. Really appreciated

[karenjoy]

Super cool functions. I wrote an array manager class without knowing a bunch of stuff and although it works well, it's certainly not as slick as yours!

[balakumar.n]

I appreciate this work! Keep making more contents. I look forward to attend the webinar today.

[alexandrumoldovan]

The content that this channel provides is just amazing. Following previous videos I switched the majority of data manipulations to arrays because they were much faster. They worked wonders but changing them was hard work, even just adding/removing a row or filtering data required a lot of code, BUT NOT ANYMORE :D!! Keep up the great work. Huge thanks!

[sumrazz]

Unmatched. This saved a tons of time and effort for my VBA application. It would be nice we can get a unique array of items given the column index.

[freeliberalminds]

Thanks for this video tutorial sir EMM. This is very helpful to my project.

[LuffyFA]

This is incredible, Paul! Your videos always teach me a lot. Thank you very much!
Greetings from Brazil.

[Planet_Xplorer]

Brilliant! You're creating your own version of Python Pandas! :-)

[EricHartwigExcelConsulting]

Fantastic video!
Eagerly awaiting the workbook source code download so I can go through it in more detail.
Thank you for creating and sharing this video!

[fernandomartinorzaez]

Hi, you are the Best vba programmer and efective teacher that I follow. Thank you very much. Please make more videos.