Excel Hack 22: Identify all cells in a range with a formula in Microsoft Excel
You may have inherited an Excel workbook that had worksheets with a combination of formula and hard-coded cells. You want to be able to quickly identify the cells with formula in them without having to step into each cell, or toggle formula view using Ctrl+~. The VBA code below will let you accomplish this in