"Redsphynx" wrote:
How do I use VBA? I have gone to that website and it is what I want to do,
but I have no clue where to start.

For starters, take away this wonderful sample from my archives:
http://savefile.com/files/377039
CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls
(Full details inside, nicely packaged:
how to install Bob's udf, how to use it in excel, etc ..)

The link given above still works, just tested the download here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---