multidimensional array
 

How do I declare a multidemensional array that has both strings and integers
in it?
Thanks

multidimensional array
 

ranswert wrote:
How do I declare a multidemensional array that has both strings and integers
in it?
Thanks
Either Dim myArray or Dim myArray(), depending on whether you want a
variant variable to contain an array, or a true array.

Alan Beban

multidimensional array
 

Dim myArr(1 To 10, 1 To 2) As Variant

OR use two arrays

Dim myIntArr(1 To 10) As Integer
Dim myStrArr(1 To 10) As String

HTH,
Bernie
MS Excel MVP


"ranswert" wrote in message
...
How do I declare a multidemensional array that has both strings and
integers
in it?
Thanks