VBA programming Using Arrays

In this lecture you shall see how using arrays makes our code run faster . I havve included a simple adding of two numbers to demonstrate this capability

This lecture discusses difference between a normal variable and an Array Variable

Option bases are discussed here . Option bases tell us how to start counting the dimensions of an array

In this lecture i am introducing the students to the concept of redim preserve

You can see Lbound and Ubound being used here . An Introduction to the same has been shown

A simple looping through 1D and 2D array has been demonstrated . This is just a demo to set the tone for the future lessons

This is a section recap video , where i have summarized the points discussed

This article tells you what you are going to see in this section

Describes the usage of bounds

This lecture shows the usage of Redim preserve in revising the last dimension of a multidimensional array . A 2D array has been shown here as an example

This lecture emphasises on the restrictions of Redim Preserve in changing any other dimension except the last dimension of a multi dimensional array

The Section Topics and the objectives are mentioned here

Learn to fill arrays with data using For loops, ideal for structured, repetitive tasks, or cases where validation is needed in ranges before adding data to an array

Use For Each to extract data from worksheet ranges efficiently

Using the Names.Add function to assign names to Arrays and Ranges . Also the usage of the visibility settings , and Evaluate methods are discussed.

1. Understand how to pass arrays into functions to make your code modular.

2. How to return arrays to calling sub/ function

3. In addition using the worksheet functions on arrays has also been discussed.

The concept of sending multiple parameters to a function has been demonstrated using the concept of Paramarrays

Helps you check whether a variable is an array, which is useful for writing error-free, flexible code that can handle different input types

You will be able to use split and join functions for processing text data and arrays

Transpose helps you to change the orientation of the array (changing rows to columns ).  As an application, in this lesson you will see how can you use transpose function to change the row dimension of a 2D array .

Filter helps return a subset of an array that meets a condition, enabling quick, in-memory filtering without looping useful for searches or extracting matches.

Erase function helps the contents of an array , deallocates its memory, which helps manage resources efficiently and reset arrays for reuse