/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

4 votes238 views2 answers
Vba create folder if not exist
VBA
0 vote173 views1 answer
Vba select file in folder
VBA
5 votes271 views1 answer
Excel vba how to unit test vba code
VBA
0 vote242 views1 answer
Compare dates vb
VBA
0 vote237 views1 answer
Switch pictures with buttons vb.net
VBA
1 vote228 views1 answer
Excel vba compare 2 rows
VBA
0 vote260 views1 answer
Return na vba
VBA
0 vote230 views1 answer
Vb check if row has column
VBA
0 vote281 views1 answer
How to enter Vbox manage commands
VBA
0 vote238 views1 answer
VBA OR vb6 find OR replace string from the end
VBA