/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

11 votes405 views1 answer
Excel vba How to URL encode a string
VBA
-1 vote279 views1 answer
For i in range vba
VBA
0 vote329 views1 answer
Visual basic run command
VBA
0 vote297 views1 answer
Prive sub enter clicked vb
VBA
0 vote311 views1 answer
Iterate all file in a folder vba
VBA
0 vote287 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote280 views1 answer
Check range is in another range vba
VBA
0 vote325 views1 answer
Excel vba convert cells address
VBA
0 vote300 views1 answer
Excel vba ternary
VBA
1 vote302 views1 answer
Vb.net get name by Selection Changed
VBA