/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

1 vote212 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
3 votes237 views1 answer
Excel vba get the workbook full filename with path
VBA
1 vote205 views1 answer
Close form vba
VBA
1 vote221 views1 answer
Export datagridview to excel vb.net
VBA
1 vote207 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote225 views1 answer
Putting marquee in vb.net
VBA
0 vote220 views1 answer
Vb.net change cursor to wait
VBA
0 vote200 views1 answer
Vbs exec hidden
VBA
1 vote224 views1 answer
How to remove zeros in excel
VBA
0 vote264 views2 answers
Excel vba store array and write to sheet
VBA