Excel Macros For Dummies. Dick Kusleika
a Worksheet on Workbook Close Unprotecting a Worksheet Opening a Workbook to a Specific Tab Opening a Specific Workbook Defined by the User Determining Whether a Workbook Is Already Open Determining Whether a Workbook Exists in a Directory Closing All Workbooks at Once Printing All Workbooks in a Directory Preventing the Workbook from Closing Until a Cell Is Populated Creating a Backup of the Current Workbook with Today’s Date Chapter 5: Working with Worksheets Installing Macros Adding and Naming a New Worksheet Deleting All but the Active Worksheet Hiding All but the Active Worksheet Unhiding All Worksheets in a Workbook Moving Worksheets Around Sorting Worksheets by Name Grouping Worksheets by Color Copying a Worksheet to a New Workbook Creating a New Workbook for Each Worksheet Printing Specified Worksheets Protecting All Worksheets Unprotecting All Worksheets Creating a Table of Contents for Your Worksheets Zooming In and Out of a Worksheet with Double-Click Highlighting the Active Row and Column
7 Part 3: One-Touch Data Manipulation Chapter 6: Feeling at Home on the Range Installing Macros Selecting and Formatting a Range Creating and Selecting Named Ranges Looping Through a Range of Cells Inserting Blank Rows in a Range Unhiding All Rows and Columns Deleting Blank Rows Deleting Blank Columns Limiting Range Movement to a Particular Area Selecting and Formatting All Formulas in a Workbook Finding and Selecting the First Blank Row or Column Chapter 7: Manipulating Data with Macros Installing Macros Copying and Pasting a Range Converting All Formulas in a Range to Values Text to Columns on All Columns Converting Trailing Minus Signs Trimming Spaces from All Cells in a Range Truncating Zip Codes to the Left Five Padding Cells with Zeros Replacing Blanks Cells with a Value Appending Text to the Left or Right of Your Cells Cleaning Up Non-Printing Characters Highlighting Duplicates in a Range of Data Hiding All but Rows Containing Duplicate Data Selectively Hiding AutoFilter Drop-down Arrows Copying Filtered Rows to a New Workbook Showing Filtered Columns in the Status Bar
8 Part 4: Macro-Charging Reports and Emails Chapter 8: Automating Common Reporting Tasks Installing Macros Refreshing All PivotTables in a Workbook Creating a List of PivotTables Adjusting All Pivot Data Field Titles Setting All Data Items to Sum Applying Number Formatting for All Data Items Sorting All Fields in Alphabetical Order Applying a Custom Sort to Data Items Applying PivotTable Restrictions Applying Pivot Field Restrictions Automatically Deleting PivotTable Drill-Down Sheets Printing a PivotTable for Each Report Filter Item Creating a New Workbook for Each Report Filter Item Resizing All Charts on a Worksheet