Quote Originally Posted by cam5778 View Post
...I would like to combine all this data into one list from the import.
Do you mean you want the data down one column?

Also - while I have not tried your current code, I seem to remember only being able to return one cell's value at a time using this method. Is there any objection to simply opening the file(s) and returning the data en mass? I think it would be much faster. for that matter, we could probably plunk a formula into the destination range(s) and overwrite with .Value = .Value.

Mark