Question : VBA - Load Array from sheet
Answered by : adorable-albatross-mew0gefbw9tc
Sub LoadArray() Dim strArray As Variant Dim TotalRows As Long TotalRows = Rows(Rows.Count).End(xlUp).Row strArray = Range(Cells(1, 1), Cells(TotalRows, 1)).Value MsgBox "Loaded " & UBound(strArray) & " items!"
End Sub
Source : https://stackoverflow.com/questions/21268383/put-entire-column-each-value-in-column-in-an-array/21269273#21269273 | Last Update : Wed, 15 Jun 22