Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to identify cells containing formulas
The following macro will do this for you - i can e-mail you this as an addin is you want which will enable you to click on a toolbar button and use it in any spreadsheet Sub ShowFormulas() Dim cell As Range On Error Resume Next Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For Each cell In Cells.SpecialCells(xlCellTypeConstants) If IsNumeric(cell.Value) Then cell.Interior.ColorIndex = 4 End If Next cell Application.Calculation = xlCalculationAutomatic End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to identify cells containing formulas
Hi, JS:
There's another argument for SpecialCells that allows you to specify just numbers (just as you can in the Goto/Special dialog box). That eliminates the need for your IsNumeric check. On Thu, 24 Jul 2003 21:04:04 +0000 (UTC), "JS" wrote: The following macro will do this for you - i can e-mail you this as an addin is you want which will enable you to click on a toolbar button and use it in any spreadsheet Sub ShowFormulas() Dim cell As Range On Error Resume Next Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For Each cell In Cells.SpecialCells(xlCellTypeConstants) If IsNumeric(cell.Value) Then cell.Interior.ColorIndex = 4 End If Next cell Application.Calculation = xlCalculationAutomatic End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify external references (in formulas) and color format | Excel Worksheet Functions | |||
How to identify offset data and execute multiple formulas | Excel Worksheet Functions | |||
Identify Text on two cells | Excel Discussion (Misc queries) | |||
How to identify text from a autofiltered list using formulas | Excel Worksheet Functions | |||
Identify cells with a value (excluding formulas) | Excel Discussion (Misc queries) |