/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 vote227 views1 answer
How to use if condition in time vba
VBA
1 vote217 views1 answer
If inputbox cancel vba
VBA
4 votes230 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote224 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote218 views1 answer
Internet explorer reference vba
VBA
0 vote217 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote211 views1 answer
Vb test if reference is null
VBA
0 vote232 views1 answer
Get month number from month name vbnet
VBA
0 vote210 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote205 views1 answer
Vb.net round to 2 decimal places
VBA