/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 vote180 views1 answer
Vba excel parser xml
VBA
-1 vote136 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote136 views1 answer
Vba array of integers
VBA
8 votes281 views1 answer
Excel vba make word from bytes
VBA
0 vote142 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote133 views1 answer
Excel vba concatenate range
VBA
1 vote149 views1 answer
Sort using vba
VBA
0 vote138 views1 answer
Remove first character from string vb
VBA
0 vote164 views1 answer
Create new worksheet excel visual basic
VBA
0 vote140 views2 answers
How to concatenate more than 40 lines in vba
VBA