Declaring a Static String Array

A static Array is an array whose size is fixed and it can be declared in two ways one is declared implicitly and another one is explicit.

  • The following code is to declare a string array implicitly.

 

  • The following code is to declare a string array explicitly.

 

How to Declare and Initialize String Array in Excel VBA?

A string array is an array where we can store only string values in the array, with the help of a string array, we can store more than one string value. We can declare the string array in many ways  like declaring a static string array, declaring a variant size array of string using the Array function, and a string array using the split function which we will discuss in this article

Similar Reads

Declaring a Static String Array

A static Array is an array whose size is fixed and it can be declared in two ways one is declared implicitly and another one is explicit....

Declaring a Variant Size Array of String using Array Function

In the following code an array is declared with variant size and string values are initialized using the array function:...

Declaring a String Array using Split Function

The following code is to declare an array without any fixed size and a split function is used to assign the string values....

Contact Us