excel vba populate array with cell values

The solution for “excel vba populate array with cell values” can be found here. The following code will assist you in solving the problem.

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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts