+ Reply to Thread
Results 1 to 4 of 4

VBA to sort sheets in a Workbook

  1. #1
    Forum Contributor
    Join Date
    10-06-2013
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    208

    VBA to sort sheets in a Workbook

    Dear All.
    I have a workbook consisting of 179 Sheets. Each sheet has a unique number 0-178,
    I need a VBA to sort and order the sheets in ascending order, literally 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 ....178.

    thanks Taisir

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: VBA to sort sheets in a Workbook

    Please Login or Register  to view this content.

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: VBA to sort sheets in a Workbook

    Hi,

    Does this work?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  4. #4
    Forum Contributor
    Join Date
    10-06-2013
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: VBA to sort sheets in a Workbook

    Dear Ranman256
    Worked perfect
    Many thanks for the prompt reply
    all the best

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-populate and sort data to a master worksheet from other sheets in a shared workbook
    By Gemma_g1985 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2014, 10:47 PM
  2. Automatically Copy sheets in one workbook to create sheets in a new workbook..
    By leebarratt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2011, 03:14 AM
  3. Macro to sort data,match and paste in to relevant sheets on same workbook
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2009, 07:58 AM
  4. Unhide sheets, sort sheets and data and rehide
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-05-2009, 07:18 PM
  5. Sort Totals & Linking Sheets in a Workbook
    By eddonaldson in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-20-2009, 11:51 AM
  6. Sort Totals & Linking Sheets in a Workbook
    By eddonaldson in forum Excel General
    Replies: 0
    Last Post: 05-20-2009, 08:04 AM
  7. how can I sort sheets within a workbook in excel
    By piagax2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2005, 06:30 PM

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