/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

8 votes236 views1 answer
Vba convert 2 bytes to an integer
VBA
9 votes229 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote175 views1 answer
Thread sleep vb
VBA
0 vote167 views1 answer
Vb.net change cursor to wait
VBA
0 vote167 views1 answer
Excel vba range contains
VBA
0 vote202 views2 answers
S yyyy-MM-dd em vb net
VBA
1 vote172 views1 answer
Vba reverse string
VBA
0 vote187 views1 answer
Vba keep command window open
VBA
0 vote207 views1 answer
Winforms dark title bar
VBA
0 vote196 views1 answer
Vba character ascii code
VBA