/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 vote181 views1 answer
Open file dialog in vb.net
VBA
0 vote180 views2 answers
Vba remove line breaks
VBA
25 votes341 views3 answers
String to date vb
VBA
0 vote183 views1 answer
Return na vba
VBA
1 vote192 views1 answer
Extract the second word in a text in excel
VBA
1 vote172 views1 answer
Vba delete file
VBA
-1 vote173 views1 answer
Text to speech vb.net
VBA
0 vote198 views1 answer
How to enter Vbox manage commands
VBA
0 vote209 views1 answer
Set datetimepicker value to null vb
VBA
1 vote174 views1 answer
Excel vba get column name from number
VBA