/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 vote191 views1 answer
Vba min
VBA
2 votes235 views1 answer
Vba round number
VBA
3 votes170 views1 answer
Excel vba read registry key value
VBA
0 vote203 views1 answer
Vba vbcrlf chr
VBA
0 vote169 views1 answer
Vbs exec hidden
VBA
0 vote175 views1 answer
Vba parameter adodb null value
VBA
0 vote186 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote185 views1 answer
Change form background image vb
VBA
1 vote174 views1 answer
Highlight selected cell in excel vba
VBA
0 vote179 views1 answer
Excel vba first working day month
VBA