/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 vote360 views1 answer
VBA Loop to range
VBA
1 vote347 views1 answer
Change the first item in a queue vb.net
VBA
0 vote360 views1 answer
Excel protect cells with formulas
VBA
0 vote339 views1 answer
Vbnet display all axis labels in cahrt
VBA
2 votes341 views1 answer
Excel vba date to string conversion
VBA
0 vote356 views1 answer
Internet explorer reference vba
VBA
0 vote359 views1 answer
.net dark title bar
VBA
0 vote376 views1 answer
Nested if else in vb.net
VBA
0 vote345 views1 answer
Vbs
VBA
0 vote367 views1 answer
Vba table header name
VBA