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

Thanks for the reply Tom but i am unsure how to add a line to the cod
that will follow the criteria if activecell.value = Date then count.

Can you help?

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27311

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

MsgBox IsDate(ActiveCell)

(without .value)

Regards,
Peter

Thanks for the reply Tom but i am unsure how to add a line to the code
that will follow the criteria if activecell.value = Date then count.

Can you help?

Simon