» Sorting Sheets in Ascending Order
CATEGORY - Excel Worksheet, Workbook
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Excel 2002
- The Guide to Understanding Financial Statements
- The 22 Immutable Laws of Branding
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
