/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 vote123 views1 answer
Excel vba protect sheet
VBA
8 votes173 views1 answer
Excel vba make word
VBA
0 vote162 views1 answer
Vbnet add axis labels to chart
VBA
0 vote148 views1 answer
Search for text in every worksheet excel visual basic
VBA
6 votes140 views1 answer
Excel vba get the path of current workbook
VBA
0 vote136 views2 answers
Excel vba protect cells with formula
VBA
0 vote120 views1 answer
Vbscript remove spaces from string
VBA
1 vote141 views1 answer
Vba optional
VBA
2 votes127 views1 answer
Vba file from path
VBA
0 vote139 views2 answers
S yyyy-MM-dd em vb net
VBA