VBA code causing excel to hangup/ not respond

[Lizardra]

Hi,
Following code is part of larger macro that will copy any file in a given folder into one spreadsheet. This part of the code works to the extent that it does the match and copies to 'combined sheet' but then it just hangs like it is still looping. Eventually excel does not respond. Appreciate any feedback on what I am doing wrong.

[Leith Ross]

Hello Lizardra,

Welcome to the Forum!

The code you posted is incomplete making it difficult to determine where the problem is. The best option to solving this problem would be to post a copy of the workbook.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

[Lizardra]

no file to attach

[Lizardra]

Any data included in files is dummy data.