Thanks Peter, was able to use the routine to produce the color index


"Peter T" <peter_t@discussions wrote in message
...
"ADK" wrote
We are currently using Excel 2000

Er, OK.

As it happens the routine I posted was written in Excell 2000.

Not sure what you are trying to convey.

Regards,
Peter T