/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 vote211 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote224 views1 answer
Vba compare strings
VBA
2 votes202 views2 answers
Constructor vb.net
VBA
0 vote205 views1 answer
Vba file size
VBA
0 vote225 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote248 views1 answer
Excel vba scroll to cell
VBA
1 vote211 views1 answer
Vba delete array element
VBA
0 vote256 views1 answer
Vba foreach 2d array
VBA
0 vote207 views1 answer
Vba word pdf table to excel
VBA
0 vote230 views1 answer
Excel vba saveas no prompt for overwrite
VBA