Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: Set order of sheets in a work book

    I need to have sheets in a specific order depending on what dept works with a file, can you set sheet order? How?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. You can use a reference worksheet to list the order you want, then use functions in a loop in VBA to cycle through to rearrange them. The attached can get you started.
    Attached Files Attached Files
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    233
    Thank you!

Posting Permissions

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