Thread: Count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ray
 
Posts: n/a
Default Count


Max,

Thanks a million for your detail and crystal clear instructions!! Learn a
lot from you.

Best regards,

Ray

"Max" wrote in message
...
Ray,

I've put together a sample file (~ "starter's kit") which contains an
implementation of Bob Phillips' ColorIndex Function from his "Processing
Coloured Cells" page at:
http://www.xldynamic.com/source/xld.ColourCounter.html
and some examples on how to use the UDF in Excel

Here's the link to the sample file (construct details inside):
http://cjoint.com/?micQQgFQvj
CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls

Hope the sample helps to get you started ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...
Max,

Thanks for your pointer. However, I am not familiar with creating VBA.

Is
it very complicate to create?

Ray