/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

3 votes176 views1 answer
Excel insert blank row for value change in column
VBA
3 votes157 views1 answer
Vba not equal
VBA
0 vote167 views1 answer
Vba first line of string
VBA
1 vote118 views1 answer
How to open cmd with vbd
VBA
0 vote174 views1 answer
Vba sort the data Z to A
VBA
0 vote184 views1 answer
Delete all controls in an area vb
VBA
0 vote163 views1 answer
Vba verticalalignment
VBA
0 vote159 views1 answer
Do while not vb.net
VBA
0 vote177 views1 answer
.net crash app
VBA
0 vote162 views1 answer
Vba leading zeros in string
VBA