/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 vote229 views1 answer
Vbs write file
VBA
0 vote246 views1 answer
Excel vba clear filter
VBA
0 vote232 views1 answer
Sendkeys vba selenium
VBA
0 vote225 views1 answer
Vbnet check if string is only symbols
VBA
1 vote229 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote237 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote239 views1 answer
Excel VBA web scraping
VBA
0 vote221 views1 answer
Dynamically change drop down list visual basic
VBA
8 votes224 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote226 views1 answer
How to extract a file from an ISO:
VBA