+ Reply to Thread
Results 1 to 2 of 2

Move sheet to another workbook loop

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    54

    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.

  2. #2
    Registered User
    Join Date
    11-05-2007
    Posts
    54

    Re: Move sheet to another workbook loop

    sorted it with the

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1