cells with formulas
 

How can I quickly identify all cells with a formula in
them?

cells with formulas
 

Tools | Options | View

Tick Formulas in Window options section


"scrabtree23" wrote in message
...
How can I quickly identify all cells with a formula in
them?

cells with formulas
 

or simply use Ctrl-` (that's the key to the left of the 1 on the top row.
This toggles the setting.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul W Smith" wrote in message
...
Tools | Options | View

Tick Formulas in Window options section


"scrabtree23" wrote in message
...
How can I quickly identify all cells with a formula in
them?

cells with formulas
 

You can use

Dim FormulaRng As Range
Set FormulaRng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormu las)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"scrabtree23" wrote in message
...
How can I quickly identify all cells with a formula in
them?

cells with formulas
 

scab

Without code....EditGo ToSpecialFormulas
Then if you have the color fill button on your toolbar..hit it.

With code......

Sub colorcells()
Dim Cel As Range
For Each Cel In ActiveSheet.UsedRange
If Cel.HasFormula Then
Cel.Interior.ColorIndex = 3 'Red
End If
Next
End Sub

Gord Dibben XL2002

On Fri, 14 Nov 2003 18:39:47 -0000, "Paul W Smith" wrote:

Tools | Options | View

Tick Formulas in Window options section


"scrabtree23" wrote in message
...
How can I quickly identify all cells with a formula in
them?