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

  • Thread starter Thread starter Simon Lloyd
  • Start date Start date
S

Simon Lloyd

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting by colour dilemma!! 1
Counting by colour dilemma!! 2
Named range not expanding with insertions after sort?? 2
count cells with diagonal borders 3
Named ranges wont expand after sort?? 4
counting formatted cells in vba 1
Move and Link2 2
how do I write a loop macro? 9

Back
Top