/VBA/Excel vba populate array with cell values

Excel vba populate array with cell values

Sub from_sheet_make_array()
   Dim thisarray As Variant
   thisarray = Range("a1:a10").Value

   counter = 1                'looping structure to look at array
   While counter <= UBound(thisarray)
      MsgBox thisarray(counter, 1)
      counter = counter + 1
   Wend
End Sub

Similar codes

0 vote324 views1 answer
Vba test optional argument
VBA
0 vote335 views1 answer
Vba integer to double
VBA
0 vote300 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
1 vote302 views1 answer
Excel vba first and last row and column in range
VBA
5 votes346 views1 answer
Excel vba right word from Long Integer
VBA
0 vote314 views1 answer
Freeze panes vba
VBA
0 vote308 views1 answer
Excel vba show developer tab
VBA
1 vote309 views1 answer
Excel vba unload userform
VBA
15 votes439 views2 answers
Xl vba dynamic string array
VBA
0 vote302 views1 answer
Vba text to general
VBA