/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 vote389 views1 answer
Excel vba urlmon
VBA
0 vote390 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote346 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote324 views1 answer
Ms access open form to new record
VBA
1 vote348 views1 answer
Close form vba
VBA
8 votes420 views1 answer
Vba make integer
VBA
1 vote366 views1 answer
Add control vb
VBA
5 votes429 views1 answer
Excel vba last byte from INTEGER
VBA
3 votes360 views2 answers
Excel "vba" match last value
VBA
0 vote349 views1 answer
Vba format currency
VBA