Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting by colour only if a cell contains a date???
Hi all, I have this code (shown below) that counts by colour (Chip Pearsons think) and it has worked fine, but i now only want the colour to b counted if the cell contains a date. Can anyone help? heres the code.............. Dim ccount As Integer Application.DisplayAlerts = False Application.DisplayFormulaBar = False Range("B5").Select ActiveCell.FormulaR1C1 "=COUNTBYCOLOR(R[9]C[-1]:R[458]C[-1],38,FALSE)" Range("B7").Select Range("d14").Select ccount = Range("b5") Thanks, 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting by colour only if a cell contains a date???
You would need to modify Chip's code I suspect.
-- Regards, Tom Ogilvy "Simon Lloyd" wrote in message ... Hi all, I have this code (shown below) that counts by colour (Chip Pearsons i think) and it has worked fine, but i now only want the colour to be counted if the cell contains a date. Can anyone help? heres the code.............. Dim ccount As Integer Application.DisplayAlerts = False Application.DisplayFormulaBar = False Range("B5").Select ActiveCell.FormulaR1C1 = "=COUNTBYCOLOR(R[9]C[-1]:R[458]C[-1],38,FALSE)" Range("B7").Select Range("d14").Select ccount = Range("b5") Thanks, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=273115 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour cell to return date | Excel Discussion (Misc queries) | |||
counting cell that are fomated a particular fill colour | Excel Discussion (Misc queries) | |||
Change cell colour by date | New Users to Excel | |||
After a cell changes colour when a date is near | Excel Discussion (Misc queries) | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) |