Run Time Error Debug help

I am opening a file, making a selection visible (is currently hidden), coping a Column, pasting values to a Column, closing the newly opened file (without saving) and moving the next file in the directory.

Currently the below code doesn't work. I need help finding the run time error reason. Also, I need the code to move to the top of the next blank column.

Any help would be really appreciated. I would rather not upload the files, but if I really need to I will.

Regards,

Please Login or Register  to view this content.

When I step through with the Debug F8 it stops and pops the error at:

Please Login or Register  to view this content.

yes all workbooks have worksheets not just the information I have created.

Run-time error '1004':
Application-defined or object -defined error

That is the run time error I get on first pass.

i will change the code to add the error catching, but I know in the DIR there are 6 files and more are populated daily (once my code is working)

after stepping back through with the error catching, I get the 1004 error at

Please Login or Register  to view this content.