/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 vote202 views1 answer
Excel vba chrw max value
VBA
0 vote209 views1 answer
Excel vba automatic calculation
VBA
1 vote220 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
2 votes194 views1 answer
Vba uppercase first letter of each word
VBA
0 vote215 views1 answer
Vbnet round to nearnest thousand
VBA
3 votes201 views1 answer
Vba request json
VBA
4 votes205 views1 answer
Excel vba check cell not empty
VBA
0 vote200 views1 answer
Vba line feed
VBA
0 vote210 views1 answer
Vbnet line graph smooth lines
VBA
0 vote222 views1 answer
Vba sort the data Z to A
VBA