Speaking of 2007... In Excel 2007 you can count by color, sum by color,
filter by color, sort by color and more.

--
Looking ahead,
Shane Devenshire


"Max" wrote:

Dave, thanks for the clarification.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
Just a comment about UDF's not working across workbooks.

If your UDF is in a workbook named Book1.xls, you can refer to a function
in
that workbook's project:

=book1.xls!ColorIndex(...)

If your UDF is in an addin, then you can refer to it just like it was
built into
excel.