Civil Engineering Projects
Macro 43: Limit Range Movement to a Particular Area
Excel gives you the ability to limit the range of cells that a user can scroll through. The ...
Macro 42: Sort a Range on Double- Click
When you distribute your Excel reports to your customers, it's often nice to add a few bells and ...
Macro 41: Apply Alternate Color Banding
Color banding is an effect where each row of a data set is colored in alternating shades (see Figure
...
Macro 40: Find and Select the First Blank Row or Column
You may often run across scenarios where you have to append rows or columns to an ...
Macro 39: Select and Format All Formulas in a Workbook
When auditing an Excel workbook, it's paramount to have a firm grasp of all the formulas ...
Macro 38: Deleting Blank Columns
Just as with blank rows, blank columns also have the potential of causing unforeseen errors. If you
find that ...
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 ...
