Opening a workbook to copy+paste data into the workbook in which sub is called stops working after it's been run unless I insert a break in the code

  • This is driving me insane. I cannot figure out why this doesn't continue running. Once it's run it will open the file and then stop. It will only run again if I put a break right before opening the file and hit F8 to get it through, then I can let it continue with F5. This makes no sense to me!!

    edit: OK, it seems to be an issue with using a shortcut key to start it. If I run it manually this doesn't happen.

  • Sorry forgot to include that

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!