/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 vote209 views1 answer
Style percent not found vba
VBA
0 vote180 views1 answer
Convert number to minutes in vba
VBA
0 vote182 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote192 views1 answer
Excel vba delete folder
VBA
0 vote179 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote189 views1 answer
Convert unix to date vba
VBA
0 vote236 views2 answers
Excel vba store array and write to sheet
VBA
0 vote199 views1 answer
Set datetimepicker value to null vb
VBA
0 vote191 views1 answer
Vba add shape oval
VBA
0 vote180 views1 answer
Vba collection key list
VBA