/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 vote234 views1 answer
Ribbon show/hide
VBA
4 votes231 views1 answer
Vba create directory
VBA
0 vote223 views1 answer
Excel vba disable keyboard input
VBA
0 vote220 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
1 vote176 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote222 views1 answer
Vba full date format
VBA
0 vote218 views1 answer
Vba add shape oval
VBA
3 votes222 views1 answer
Excel vba read registry key value
VBA
0 vote262 views1 answer
Vbnet check if string is only numbers
VBA
0 vote249 views1 answer
For each item in folder outlook vba
VBA