/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 vote264 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote281 views1 answer
Vba compare strings
VBA
18 votes399 views2 answers
Vba make word from bytes
VBA
0 vote291 views1 answer
Vba remove the first character of string
VBA
1 vote282 views2 answers
Get all column names from excel vba
VBA
27 votes385 views2 answers
Vba check if file exists
VBA
22 votes383 views1 answer
Excel vba check if directory exists
VBA
0 vote277 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote258 views1 answer
Check if program is running vbnet
VBA
0 vote258 views1 answer
Excel vba disable alerts
VBA