Count cells with fill color and retain code - Mr. Umlas Can you he

  • Thread starter Counting Cells With Fill Color
  • Start date
C

Counting Cells With Fill Color

I copied some VBE code from
http://xldynamic.com/source/sld.ColourCounter.html and pasted it into the VBA
editor in my Excel spreadsheet. Then I used '=ColorIndex(cell)='color index
number' to find out what index number my color is. Then I used
'=SumProduct(--(COLORINDEX(cell range)='color index number')) to add up the
cells that have that color. This works great. However, when I save the
Excel document and then need to go back to it, I get a #name? error. Why is
this happening. I really would like to be able to use this code, but can't
figure out why it doesn't work correctly.

Thanks,

Pam Mahan
 
B

Billy Liddel

Pam

Press the F9 key to force calculation and it should work. Excel does not
recognise UDFs imediately unless they are installed in an AddIn.

Peter
 

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

Help using Chip Pearsons code to count cells with color 9
Counting cells with a specific fill color 2
How to add up all cells with no fill color 9
Printed Material Missing Fill Color 6
Excel 2003 - Color changing cells 1
count cells with diagonal borders 3
SUMPRODUCT to count cells with background color 3
How can I sum numbers that have a gray color-fill in cell? 1

Top