Declare and Initialize String Array in VBA

by

Try this:

' Variant array    
Dim myVariantArray As Variant
myVariantArray = Array("Cat", "Dog", "Rabbit")

' String array
Dim myStringArray() As String
myStringArray = Split("Cat,Dog,Rabbit", ",")

More Related Contents:

  1. Excel-VBA – Insert new first column in datafield array without loops or API calls
  2. Creating an Array from a Range in VBA
  3. Expanding column cells for each column cell
  4. How do I slice an array in Excel VBA?
  5. Swift: Creating an Array with a Default Value of distinct object instances
  6. Check if a value is in an array or not with Excel VBA
  7. How to search for string in an array
  8. Sorting a multidimensionnal array in VBA
  9. How do I set up a “jagged array” in VBA?
  10. Matching values in string array
  11. Deleting Elements in an Array if Element is a Certain value VBA
  12. Is it possible to fill an array with row numbers which match a certain criteria without looping?
  13. Return Index of an Element in an Array Excel VBA
  14. Writing an array to a range. Only getting first value of array
  15. Excel VBA: Range to String Array in 1 step
  16. Faster way of using Sumifs()
  17. How to initialize a multidimensional array variable in vba for excel
  18. VBA using ubound on a multidimensional array
  19. Turn Excel range into VBA string
  20. Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)
  21. Why am I having issues assigning a Range to an Array of Variants
  22. Is there a way to not have to initialize arrays twice?
  23. Subscript out of range error with an array – no idea why?
  24. VBA Excel large data manipulation taking forever
  25. Performance difference between looping range vs looping array
  26. VBA – Returning array from Property Get
  27. How do I Merge two Arrays in VBA?
  28. Excel VBA Quickest way to sort an array of numbers in descending order?
  29. Keyed items in golang array initialization
  30. Excel VBA – How to Redim a 2D array?

Leave a Comment