Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique Formulas in Excel 2002-2003
Excel 2002 and 2003 have a feature which identifies unique formulas in a
range. It puts a little green tag in the top right hand corner of the cells which it deems unique. What is the property for this? I am assuming that this is a Boolean (TRUE/FLASE). Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique Formulas in Excel 2002-2003
Actually the Error Checking feature can detect 8 faux pas' as Excel sees it.
The one you mentioned isn't really 'unique formula' but rather 'inconsistent formula' which is not exactly the same thing. Anyway to detect the errors a cell may have you can use code like this. This code reports errors regardless of whether error checking is enabled or what rules are selected. Also it reports all errors that apply, not just the first. Sub TestActiveCell() Dim ErrDesc As String ErrDesc = GetErrType(ActiveCell) If ErrDesc < "" Then MsgBox GetErrType(ActiveCell) End Sub Function GetErrType(Rg As Range) As String Dim Counter As Integer Dim ErrObj As Error Dim ErrText As String For Counter = 1 To 8 Set ErrObj = Rg.Errors(Counter) If ErrObj.Value Then ErrText = ErrText & Choose(Counter, "Formula is Error", _ "2 Digit Year", "Number as Text", "Inconsistent Formula", _ "Omitted Cells", "Unlocked Formula", "Empty Ref Cell", _ "Data Validation Error") & "," End If Next If ErrText < "" Then _ GetErrType = Left(ErrText, Len(ErrText) - 1) End Function -- Jim "ExcelMonkey" wrote in message ... | Excel 2002 and 2003 have a feature which identifies unique formulas in a | range. It puts a little green tag in the top right hand corner of the cells | which it deems unique. What is the property for this? I am assuming that | this is a Boolean (TRUE/FLASE). | | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Advance filter -How to select table with unique refere | Excel Discussion (Misc queries) | |||
Excel 2002: Max, Min and Average formulas | Excel Discussion (Misc queries) | |||
MS Excel 2002 formulas | Excel Worksheet Functions | |||
Excel 2002 - How to keep the formulas unchanged ? | Excel Discussion (Misc queries) | |||
Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming |