/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 vote148 views1 answer
Excel vba saveas force overwrite
VBA
0 vote163 views1 answer
Vb.net change cursor to wait
VBA
0 vote152 views1 answer
Test if form is open vb
VBA
0 vote169 views1 answer
Reset border color textbox vba
VBA
-1 vote168 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote155 views1 answer
Compare dates vb
VBA
1 vote164 views1 answer
Excel vba autofit
VBA
0 vote171 views1 answer
Vba table header name
VBA
0 vote143 views1 answer
Vba word pdf table to excel
VBA
0 vote168 views1 answer
Vb run command
VBA