/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 vote325 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote339 views1 answer
Excel vba chrw max value
VBA
0 vote314 views2 answers
Excel vba close without saving
VBA
2 votes317 views1 answer
Vba array contains
VBA
0 vote334 views1 answer
Vba first cell in range
VBA
1 vote351 views2 answers
Get all column names from excel vba
VBA
1 vote344 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
3 votes328 views1 answer
Vba make long from two shorts
VBA
0 vote340 views1 answer
Make all controls in an area not visable vb
VBA
0 vote342 views1 answer
Excel vba protect content
VBA