/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 vote186 views2 answers
Get excel file from email attachment in vba
VBA
3 votes197 views1 answer
Vba post request json
VBA
0 vote188 views1 answer
Vba find sub dictionary
VBA
2 votes249 views1 answer
Vba round number
VBA
0 vote193 views1 answer
How to add line graph vb net
VBA
9 votes408 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote187 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote189 views1 answer
Limit combobox to list vba
VBA
0 vote172 views1 answer
Vba first cell in range
VBA
1 vote190 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA