/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

1 vote144 views1 answer
Ms access open form to new record
VBA
1 vote227 views1 answer
Vba loop through files in folder
VBA
0 vote193 views1 answer
Type excel.application is not defined vb
VBA
0 vote179 views1 answer
Vbnet make a string to unicode converter
VBA
3 votes237 views2 answers
Vba date to string
VBA
0 vote216 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote207 views1 answer
Export datagridview to excel vb.net
VBA
1 vote155 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote210 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote197 views1 answer
How to extract a file from an ISO:
VBA