Learn

Latest Posts

Macro 37: Deleting Blank Rows

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

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

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

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

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

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

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

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

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

Macro 28: Create a Table of Contents for Your Worksheets Outside of sorting worksheets, creating a table of contents for the worksheets in a ...

Share knowledge
Learn
Logo
Enable registration in settings - general