CATEGORY: Excel Worksheet, Workbook VERSIONS: All Microsoft Excel Versions

To sort the sheets in ascending order: 1. Press Alt+F11, and then select a VBAProject (for example, press VBAProject (Financial Statements.xls)). 2. From the Insert menu, select Module. 3. In the Module, type the code lines displayed in the SheetInABC_Order macro in the screenshot. 4. Operate the macro from the Module by pressing F5. OR Press Alt+F11 and return to Excel, assign the macro to any Excel object as a button or icon, or press Alt+F8 to select the macro, and then click Run.

Screenshot // Sorting Sheets in Ascending Order

Rate this tip 1 2 3 4 5   RATING: 3.10   VIEWS: 17020 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition) The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not! Windows XP for Dummies Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports Microsoft Windows XP Step by Step (With CD-ROM)

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books