The problem I have is that I have some VBA code which contains a loop where new sheets are created and data transfered over to them..... which all works fine
but what I want to do is once complete, before looping to the next worksheet, "move" this worksheet to a new workbook.
The problem I have is that it appears that once the sheet has been moved into the new workbook, the code then tries to carry on from within that workbook???
How can I tell the code to return to the first workbook to then carry on with the loop.
Thanks in advanced.
Bookmarks