Learn
Macro 37: Deleting Blank Rows Work with Excel long enough, and you'll find out that blank rows can often cause havoc on many levels. They can ...
Macro 36: Unhide All Rows and Columns When you are auditing a spreadsheet that you did not create, you often want to ensure you're get- ting a ...
Macro 35: Inserting Blank Rows in a Range Occasionally, you may need to dynamically insert rows into your dataset. Although blank rows are ...
Macro 34: Select and Format All Named Ranges If you spend your time auditing other people's worksheets, you'll know that Excel users love their ...
Macro 33: Enumerating Through a Range of Cells One must-have VBA skill is the ability to enumerate (or loop) through a range. If you do any ...
Macro 32: Creating and Selecting Named Ranges One of the more useful features in Excel is the ability to name your range (that is, to give your ...
Macro 31: Selecting and Formatting a Range One of the basic things you need to do in VBA is to select a specific range to do something with it. ...
Macro 30: Highlight the Active Row and Column When looking at a table of numbers, it would be nice if Excel automatically highlighted the row and ...
Macro 29: Zooming In and Out of a Worksheet with Double-Click Some spreadsheets are huge. Sometimes, we are forced to shrink the font size down ...
Macro 28: Create a Table of Contents for Your Worksheets Outside of sorting worksheets, creating a table of contents for the worksheets in a ...
