Excel VBA Excel VBA Data Manipulation & Arrays

Question 1

How do you declare a dynamic array in VBA?

Accepted Answer

Dim arr() As Integer

Answer

A dynamic array is declared with empty parentheses (Dim arr() As Integer) and resized later with ReDim.

Question 2

Which VBA statement resizes a dynamic array while preserving existing data?

Accepted Answer

ReDim Preserve arr(20)

Answer

ReDim Preserve resizes the array to the new size while keeping all previously stored values intact.

Question 3

What does the LBound() function return for an array?

Accepted Answer

The first valid index

Answer

LBound() returns the lowest subscript (first valid index) of the specified array dimension.

Question 4

In VBA, how do you declare a two-dimensional array with 3 rows and 4 columns?

Accepted Answer

Dim arr(2, 3) As Integer

Answer

Since VBA arrays are zero-based by default, Dim arr(2, 3) creates indices 0–2 and 0–3, giving 3 rows and 4 columns.

Question 5

Which built-in VBA function splits a string into an array using a delimiter?

Accepted Answer

Split()

Answer

The Split() function divides a string by a specified delimiter and returns a zero-based string array.

Excel VBA Practice Test