As you can see, VBA offers a number of opportunities to tailor Excel functions to your needs. Once you master it, you'll find it extremely powerful and productive.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...

7: Reference Worksheet objects The Worksheets collection contains all the sheet objects in a workbook. Using a simple For Each loop, you can cycle through the collection.

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.