counting by colour only if a cell contains a date???

[Simon Lloyd]

Sorry Peter you have lost me here!, can you explain what it was you wer
trying to get me to do?

Simo

 

[Tom Ogilvy]

Function CountByColor(InRange As Range, _
WhatColorIndex As Integer, _
Optional OfText As Boolean = False) As Long
'
' This function return the number of cells in InRange with
' a background color, or if OfText is True a font color,
' equal to WhatColorIndex.
'
Dim Rng As Range
Application.Volatile True

For Each Rng In InRange.Cells
if isdate(rng) then
If OfText = True Then
CountByColor = CountByColor - _
(Rng.Font.ColorIndex = WhatColorIndex)
Else
CountByColor = CountByColor - _
(Rng.Interior.ColorIndex = WhatColorIndex)
End If
End if
Next Rng

End Function

 

[Peter T]

Sorry Peter you have lost me here!, can you explain what it was you were
trying to get me to do?

In your previous post you asked:
and in reply I suggested IsDate(ActiveCell)

But I can see now I misread your question, sorry!
I thought you wanted to check if the cell contain a valid date rather than
than if the cell contains today's date.

Regards,
Peter