/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 vote149 views1 answer
Select case vba
VBA
0 vote151 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote106 views1 answer
Vba set vs dim
VBA
0 vote151 views1 answer
Vba type
VBA
-1 vote173 views1 answer
How save excel through visual basic
VBA
0 vote150 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote155 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote142 views1 answer
Vba copy paste value only
VBA
8 votes271 views1 answer
Vba make a short integer from two bytes
VBA
0 vote143 views1 answer
Excel vba current folder
VBA