Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
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 4-5). You would typically apply alternating row colors to reports you distribute to people who need to review each row of data. Color banding makes the data a little easier […]
Macro 41: Apply Alternate Color Banding Read More »
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 existing data set. When you need to append rows, you will need to be able to find the last used row and then move down to the next
Macro 40: Find and Select the First Blank Row or Column Read More »
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 in each sheet. This means finding all the formulas, which can be an arduous task if done manually. However, Excel provides us with a slick way of finding and
Macro 39: Select and Format All Formulas in a Workbook Read More »
Macro 38: Deleting Blank Columns Just as with blank rows, blank columns also have the potential of causing unforeseen errors. If you find that you are manually searching out and deleting blank columns in your data sets, this macro can automate that task. How it works In this macro, we are using the UsedRange property
Macro 38: Deleting Blank Columns Read More »
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 cause problems with formulas, introduce risk when copying and pasting, and some- times cause strange behaviors in PivotTables. If you find that you are manually searching out and deleting
Macro 37: Deleting Blank Rows Read More »
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 full view of what is exactly in the spreadsheet. To do so, you need to ensure that no columns and rows are hidden. This simple macro automatically unhides
Macro 36: Unhide All Rows and Columns Read More »
Macro 35: Inserting Blank Rows in a Range Occasionally, you may need to dynamically insert rows into your dataset. Although blank rows are generally bothersome, in some situations, the final formatted version of your report requires them to separate data. The macro in this section adds blank rows into a range. How it works This
Macro 35: Inserting Blank Rows in a Range Read More »
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 named ranges. It’s not uncommon to encounter spreadsheets where dozens of cells and ranges are given individual names. This makes auditing a spreadsheet an extremely muddy experience. It some- times helps
Macro 34: Select and Format All Named Ranges Read More »
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 serious macro work in Excel, you will soon encounter the need to go through a range of cells one by one and perform some action. This basic macro shows
Macro 33: Enumerating Through a Range of Cells Read More »
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 range a user-friendly name, so that you can more easily identify and refer to it via VBA). Here are the steps you would perform to create a named
Macro 32: Creating and Selecting Named Ranges Read More »
