R ranswert Jan 16, 2008 #1 How do I declare a multidemensional array that has both strings and integers in it? Thanks
A Alan Beban Jan 17, 2008 #2 ranswert said: How do I declare a multidemensional array that has both strings and integers in it? Thanks Click to expand... Either Dim myArray or Dim myArray(), depending on whether you want a variant variable to contain an array, or a true array. Alan Beban
ranswert said: How do I declare a multidemensional array that has both strings and integers in it? Thanks Click to expand... Either Dim myArray or Dim myArray(), depending on whether you want a variant variable to contain an array, or a true array. Alan Beban
B Bernie Deitrick Jan 17, 2008 #3 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
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