/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 vote139 views1 answer
Excel last used row
VBA
4 votes142 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
1 vote134 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
2 votes126 views1 answer
Excel vba extract file name
VBA
0 vote134 views1 answer
Refresh token em vb net
VBA
1 vote141 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote142 views1 answer
Vba paste values
VBA
0 vote138 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote152 views1 answer
Excel vba move down to next visible cell
VBA
1 vote152 views1 answer
Excel vba convert text YYYYMMDD to date
VBA