Move sheet to another workbook loop
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.
Last edited by karl1985; 09-09-2011 at 04:27 AM.
Re: Move sheet to another workbook loop
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1