Log In
Or create an account -> 
Imperial Library
  • Home
  • About
  • News
  • Upload
  • Forum
  • Help
  • Login/SignUp

Index
INTRODUCTION Download the Free Macro Workbook Version Comments GETTING STARTED WITH VBA What is VBA? Why do People use VBA? Common VBA Terms Adding the Developer Tab to the Ribbon Visual Basic Editor Overview How to Insert a Module in the Visual Basic Editor (VBE) How to Run Macros WORKSHEET MACROS Unhide all Worksheets Hide all Worksheets Except the Active Sheet Sort Worksheets Alphabetically Unhide all Rows and Columns Unmerge all Merged Cells Auto Fit Columns Auto Fit Rows Protect all Worksheets Unprotect all Worksheets Insert Multiple Columns Insert Multiple Rows Remove Wrap Text Delete all Worksheets Except the Active Worksheet WORKBOOK MACROS Create a Backup of the Current Workbook Close all Workbooks Copy Active Worksheet into a New Workbook Create an Email Message and Attach Active Workbook Attach Workbook to an Email HIGHLIGHTING MACROS Highlight Blank Cells Highlight Duplicate Values from a Selection Highlight Alternative Rows in a Selection Highlight Cells with Misspelled Words Highlight Specific Text Highlight Negative Numbers Highlight Cells with Comments CHART MACROS Create a Chart Format all Charts Add Chart Title Paste Chart as an Image FORMULA MACROS Remove Spaces from Selected Cells Convert Date into Day Convert Date into Year Remove Time from a Date Remove Date from Date and Time Convert Text to Upper Case Convert Text to Lower Case Convert Text to Proper Case Convert Text to Sentence Case Word Count an Entire Worksheet Remove an Apostrophe Infront of a Number Remove Decimals from Numbers Multiply Numbers by a Specified Amount Remove Negative Signs from Numbers Replace Blank Cells with Zeros Insert A-Z Alphabets in a Range in Upper Case Insert A-Z Alphabets in a Range in Lower Case Remove Characters from a String Insert Degree Symbols PIVOT TABLE MACROS Create a New Pivot Table Delete all Pivot Tables in the Workbook Delete a Specific Pivot Table Hide Subtotals in a Pivot Table Unhide Subtotals in a Pivot Table Refresh all Pivot Tables in a Workbook Enable the GETPIVOTDATA Function Disable the GETPIVOTDATA Function ADVANCED MACROS Save a Selected Range as a PDF Convert Range to an Image Use Text to Speech Activate a Data Entry Form Create a Table of Contents MORE BOOKS BY EXCEL MASTER CONSULTANT ABOUT THE AUTHOR
  • ← Prev
  • Back
  • Next →
  • ← Prev
  • Back
  • Next →

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab.

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion