/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 vote355 views1 answer
Excel vba combine ranges
VBA
0 vote369 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote332 views1 answer
Vba check if class implements interface
VBA
0 vote320 views1 answer
Vb window.minimize
VBA
0 vote348 views1 answer
Excel vba protect sheet
VBA
0 vote339 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote316 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote347 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
1 vote316 views1 answer
Textbox find and replace vb
VBA
0 vote331 views1 answer
Excel run macro every 5 minutes
VBA