/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 vote180 views1 answer
Vba set vs dim
VBA
0 vote232 views1 answer
Vba string
VBA
-1 vote215 views1 answer
Vba code to add new column in table
VBA
0 vote230 views2 answers
Open url from vba
VBA
0 vote241 views1 answer
Vba table header name
VBA
0 vote246 views1 answer
Vba verticalalignment
VBA
0 vote245 views2 answers
Delete all controls from list of control vb.net
VBA
1 vote198 views1 answer
Vba listindex select multiple items vba
VBA
8 votes531 views1 answer
Excel vba make word from bytes
VBA
5 votes199 views1 answer
Vba array worksheet.index
VBA