Results 1 to 6 of 6

Thread: [RESOLVED] Move Method Excel VBA

Threaded View

  1. Mar 22nd, 2006, 03:40 PM #1
    billhuard
    billhuard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    Montreal, Canada
    Posts
    152

    Resolved [RESOLVED] Move Method Excel VBA

    I'm trying to move worksheet from workbook 1 to workbook 2 using a loop.

    The 12 first iterations work fine, at the thirdteen attempt I'm getting a Move Method of worksheet class failed.

    I'm in a loop, so if the 12 first work why not the other. Is there a limit of sheet that can be moved.

    So both workbook exist
    The sheet to be moved exist
    There is still a lot of memory available.
    And I'm not able to manually move the sheet too.
    But I can add a new sheet
    Excel 2003


    So what the F

    One keyboard down
    Last edited by billhuard; Mar 22nd, 2006 at 03:43 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width