/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 vote72 views1 answer
Vba exit do while
VBA
0 vote129 views1 answer
Vb ternary
VBA
0 vote128 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote112 views1 answer
Vba string start with
VBA
0 vote128 views1 answer
For each item in folder outlook vba
VBA
22 votes212 views1 answer
Xl vba check for folder
VBA
0 vote126 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote129 views1 answer
WGET FTP
VBA
0 vote123 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote117 views2 answers
Excel vba protect cells with formula
VBA