Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells with formulas
How can I quickly identify all cells with a formula in
them? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Cells and formulas | Excel Worksheet Functions | |||
formulas and cells | Excel Worksheet Functions | |||
how to sum cells that already have formulas | Excel Discussion (Misc queries) | |||
How do I sum cells containing formulas ? | Excel Worksheet Functions |