Importing Multiple Text Files to one excel Sheet

Greetings,

I found this code that uploads multiple text files to one sheet:

Please Login or Register  to view this content.

I am looking for the change to this code that would offset in the other direction. I.e., this code pastes the data in the next available cell to the right, I would like it to paste the dat in the next available cell below. I tried swapping the "Rows.Count" statement in the iif statement, but it didn't work properly.