Declare and Initialize String Array in VBA

arrays vba initialization
Kairan picture Kairan · Oct 14, 2013 · Viewed 690.9k times · Source

This should work according to another stack overflow post but its not:

Dim arrWsNames As String() = {"Value1", "Value2"}

Can anyone let me know what is wrong?

Answer

Eldar Agalarov picture Eldar Agalarov · Oct 14, 2013

Try this: 

Dim myarray As Variant
myarray = Array("Cat", "Dog", "Rabbit")

Related questions

How to clear the entire array?

I have an array like this: Dim aFirstArray() As Variant How do I clear the entire array? What about a collection?

Read More
How to find if an array contains a string

Possible Duplicate: How to search for string in MS Access VBA array I am currently working on an Excel macro, and I could not find a way to do like if array.contains(mystring) I wrote the following, and it …

Read More
VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More