/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 vote241 views1 answer
Vba range clear formatting
VBA
0 vote226 views1 answer
Vbscript check if string is empty
VBA
27 votes489 views2 answers
Vba check if file exists
VBA
0 vote216 views1 answer
Afficher un message d'erreur vba
VBA
0 vote211 views2 answers
Excel vba prevent save
VBA
31 votes513 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote230 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote242 views1 answer
Vba integer to double
VBA
0 vote227 views1 answer
Average vba
VBA
3 votes255 views2 answers
Vba active workbook path
VBA