| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function not computing (#VALUE!) returned
Function CdlColorCountIf(SearchArea As Range, CdlBgColor As Integer) As Integer
Dim CellCount As Range Application.Volatile True For Each CellCount In SearchArea If CellCount.Interior.ColorIndex = CdlBgColor Then CdlColorCountIf = CdlColorCountIf + 1 End If Next CellCount Calculate End Function Thanks. Asheesh --------------------- what does the code look like? -- HTH Bob Phillips |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returned in vlookup function | New Users to Excel | |||
| Wrong output returned during IF function | Excel Worksheet Functions | |||
| How do I set a minimum value to be returned from IF function | Excel Discussion (Misc queries) | |||
| Using the returned value of a function | New Users to Excel | |||
| Preformatted array returned by custom function | Excel Programming | |||
Threaded Mode
