/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 vote272 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote303 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote312 views1 answer
Vba excel parser xml
VBA
5 votes343 views2 answers
Excel vba write to the windows registry
VBA
2 votes299 views1 answer
Vba split string
VBA
0 vote258 views1 answer
Excel vba linter
VBA
3 votes333 views1 answer
Vba post request json
VBA
0 vote314 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote299 views1 answer
VBA Sort RossetaCode
VBA
22 votes428 views1 answer
Excelvba check for directory
VBA