/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

1 vote304 views1 answer
Excel vba to lower case
VBA
0 vote296 views1 answer
Vba cell all borders
VBA
5 votes274 views1 answer
Excel vba high word from Long Integer
VBA
1 vote299 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
1 vote265 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote289 views1 answer
Do while not vb.net
VBA
0 vote306 views1 answer
Create links in msgbox in vb
VBA
2 votes283 views2 answers
Excel vba copy values range to another range
VBA
0 vote301 views1 answer
Vba array dimensions
VBA
0 vote277 views1 answer
Refresh token em vb net
VBA