macro to find all formulas in a workbook
 

Anyone have a macro that highlights all the formulas in a workbook and shades
the cell a given color?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

macro to find all formulas in a workbook
 

For the active sheet in yellow:

Sub dave()
Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormu las)
r.Interior.ColorIndex = 6
End Sub

--
Gary''s Student
gsnu200711

macro to find all formulas in a workbook
 

click F5 Special select Formulas Ok select any color you want Enter


"Dave F" wrote:

Anyone have a macro that highlights all the formulas in a workbook and shades
the cell a given color?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.