Thanks for the replies!!
Changing to Next x has the same result. It works from VBA but not from clicking the button.
I also tried AlphaFrog's code (MUCH more succint than my mess!!!). It only pastes the last workbooks data, ignoring any of the previous ones.
Any idea why clicking the button on my code would disable a loop?
Bookmarks