/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 vote321 views1 answer
Vlookup columns not next to each other
VBA
0 vote312 views1 answer
Excel autofilter vba
VBA
0 vote323 views1 answer
Vb net check if file exists
VBA
0 vote330 views1 answer
Do while not vb.net
VBA
0 vote341 views1 answer
How to add line graph vb net
VBA
3 votes358 views1 answer
Vba double quote
VBA
0 vote324 views1 answer
Change whcih control a user has selected vb
VBA
0 vote336 views1 answer
Excel text to columns line break
VBA
0 vote344 views1 answer
Send webhook vbscript
VBA
0 vote330 views1 answer
Backspace key has stopped working visual studio
VBA