/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 vote199 views1 answer
Vba createparameter null
VBA
3 votes206 views1 answer
Excel vba read registry key value
VBA
0 vote222 views1 answer
VB Error Code BC30201
VBA
0 vote202 views1 answer
Vba border weight
VBA
31 votes463 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote209 views1 answer
Vba sheet visible
VBA
0 vote158 views1 answer
How to sort datagridview in vb.net
VBA
0 vote212 views1 answer
Rotate image by any angle vb.net
VBA
3 votes228 views1 answer
Vba continue for each loop
VBA
0 vote220 views1 answer
Vba sheet hide unhide
VBA