/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 vote296 views1 answer
Excel vba delete columns in range
VBA
0 vote233 views1 answer
Search combobox items vb.net
VBA
0 vote222 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote228 views1 answer
Excel vba extract year
VBA
0 vote240 views1 answer
.net dark title bar
VBA
1 vote223 views1 answer
Excel vba saveas force overwrite
VBA
5 votes249 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote228 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote226 views1 answer
Compare dates vb
VBA
0 vote225 views1 answer
Vba boolean to string
VBA