1. Use Relative cell references Always use Relative cell references/addresses (the default is Absolute references) unless your macro is for one specific application in one spreadsheet.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.