You have to enable macros when you open the sample file, otherwise it won't
work, and you'll get the errors. Bob's ColorIndex Function is already
implemented in the sample.

Try it again. It should work.

You could also try saving the file first to harddisk from the link, viz.:
Right-click on "Download File" choose "Save Target As"
Then open the file from the folder you saved it to, enabling macros of
course.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kelly Lim" wrote in message
...
Hi Max, ....i download and open the url that u gave me....but y does the
whole column of

(1) Extracting ColorIndexes from E2:E5
(3) Count No of cells within the source range with the color

becomes #NAME?
#NAME?