/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

1 vote361 views1 answer
Perform http request in vb.net
VBA
0 vote326 views1 answer
Group controls programmatically vb
VBA
0 vote322 views2 answers
Open url from vba
VBA
0 vote299 views1 answer
Vba add month to date
VBA
0 vote336 views4 answers
Vgrive,deb
VBA
5 votes297 views1 answer
Excel vba high word from Long Integer
VBA
0 vote327 views4 answers
Jwt token vb.net validation
VBA
0 vote353 views1 answer
Vbs run with cscript
VBA
0 vote297 views1 answer
Vbs send keys
VBA
0 vote311 views1 answer
Worksheet.pastespecial textbox
VBA