VBA Loops

Hi

The code below is a loop VBA macro i have which loops through a foder and finds all teh files which are in a list and then opens them and copies the data in Column E and pastes it into the next clean column.

However there is an if statement attachted to the loop which states that if there is a file which is not on the list to skip that fiel and go to the next one on the list. But i need to change this so it says if the file is not the list to skip the file but also leave a blank column and paste the data from the next file in the column next to the blank column.

so it looks like this:
d a Blank a a

Please Login or Register  to view this content.

Does anyone know how to do this?

Thanks

Jeskit

You just need to increment the write column whether the file exists or not:

Please Login or Register  to view this content.

Dom