Civil Engineering Projects
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 ...
Macro 27: Unprotect All Worksheets
You may find yourself constantly having to unprotect multiple worksheets manually. The following
macro does ...
Macro 26: Protect All Worksheets
Before you distribute your workbook, you may want to apply sheet protection to all of the sheets.
Instead of ...
Macro 25: Print Specified Worksheets
If you want to print specific sheets manually in Excel, you need to hold down the CTRL key on the
...
Macro 24: Create a New Workbook for Each Worksheet
Many Excel analysts need to parse their workbooks into separate books per worksheet tab. In ...
Macro 23: Copy a Worksheet to a New Workbook
In Excel, you can manually copy an entire sheet to a new workbook by right-clicking the target sheet ...
Macro 22: Group Worksheets by Color
Many of us assign colors to our worksheet tabs. This allows for the visual confirmation that the data
in a ...
Macro 21: Sort Worksheets by Name
You may often need to sort worksheets alphabetically by name. You would think Excel would have a
native function ...
Macro 20: Moving Worksheets Around
We've all had to rearrange our spreadsheet so that some sheet came before or after other sheet. If
you find ...
