Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

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.