Arrays (97)

Topic

New Reply

I have a worksheet with string data in column “A”, that I would like to load into an array. I know how to loop through the data and count the number rows (data elements), but am lost as to loading the elements into the array.

Reply | Quote

Replies

And then what?

Reply | Quote

You need to set up an array with

Dim Names()

then establish th enumber of elements in th ethe array and ReDim Names(No of Elements)

You can then loop through your range and assign the values to the array elements something like :-

For i = 1 to NoOfElements
Names(i) = Range(FirstCell).Offset(i,0).value
Next

Reply | Quote