Results 1 to 5 of 5

Thread: Insert many worksheets and name

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by Zaigham View Post
    Hi Admin

    It works fine. Just inserts sheets in descending order and it is not a big problem. I am really thankful to you.
    If you want the order reversed, then change Admin's For statement to this...

    Code:
    For i = UBound(NameList, 1) To 1 Step -1

  2. #2
    Junior Member Zaigham's Avatar
    Join Date
    Mar 2013
    Posts
    13
    Rep Power
    0
    Now it works very fine. Thank you very much.

Similar Threads

  1. Delete worksheets without loop
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 03-04-2014, 07:29 PM
  2. Calculating data from other Worksheets
    By Ribice in forum Excel Help
    Replies: 4
    Last Post: 12-27-2013, 11:32 AM
  3. Copy Automatically Between Two Worksheets
    By marreco in forum Excel Help
    Replies: 0
    Last Post: 08-27-2012, 04:48 PM
  4. Protecting Elements in Worksheets
    By LeeL in forum Excel Help
    Replies: 1
    Last Post: 07-29-2011, 07:32 AM
  5. Merge Multiple Worksheets into One
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 05-04-2011, 04:15 AM

Posting Permissions

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