/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 vote363 views1 answer
Vba leading zeros in string
VBA
0 vote385 views1 answer
Vba random number
VBA
0 vote332 views1 answer
Create new worksheet excel visual basic
VBA
0 vote372 views2 answers
Get unique random number in vb.net
VBA
0 vote427 views1 answer
Visual basic run command
VBA
3 votes335 views1 answer
Excel vba last row in range
VBA
5 votes937 views1 answer
Vlookup vba
VBA
0 vote355 views1 answer
Remove series name from legendvbnet
VBA
-1 vote401 views1 answer
How save excel through visual basic
VBA
1 vote351 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA