/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 vote158 views1 answer
Excel vba protect worksheet without password
VBA
0 vote160 views1 answer
String contins in vba
VBA
0 vote147 views1 answer
Do while not vb.net
VBA
2 votes158 views2 answers
Vba code to remove duplicates from a column
VBA
3 votes166 views1 answer
Vba double quote
VBA
0 vote165 views1 answer
Regex numeric digits
VBA
1 vote147 views2 answers
Get all column names from excel vba
VBA
0 vote146 views1 answer
Vbnet line graph smooth lines
VBA
0 vote140 views1 answer
Find days in month vba
VBA
18 votes322 views2 answers
Vba make word from bytes
VBA