/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 vote177 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote187 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote196 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote190 views1 answer
Excel vba formatconditions range
VBA
0 vote177 views2 answers
Excel vba prevent save
VBA
2 votes173 views1 answer
Vba array contains
VBA
0 vote184 views1 answer
Enable macros on opening workbook vba
VBA
0 vote198 views1 answer
Vba check if class implements interface
VBA
0 vote206 views1 answer
Excel web scraping
VBA
8 votes299 views1 answer
Excel vba make a short integer from two bytes
VBA