Help Identifying Coding Errors - Any Suggestions Greatly Appreciated

Hi there, I am wondering if there are any experts that can have a look and advise what I am doing wrong with the codes below. I've adapted the codes from www.TheSpreadsheetGuru.com which basically opens up all the Excel spreadsheets in a given folder and copy/paste the information into the master spreadsheet.

If I open my master spreadsheet and run the macro it actually works fine. However, if I clear the contents in the master spreadsheet first or run the macro more than once then Excel would just shut itself down - I can't see anything that's obviously wrong with the codes so would appreciate any help with this

Thanks in advance

Please Login or Register  to view this content.

[/COLOR]

To all other users - Note this is the same issue reposted as this thread

http://www.excelforum.com/showthread...t=#post4553440