The above function is not set up in Excel. Do I need to set it up or can I
copy it in?
--
All help appreciated.

Hi Nell

Colorindex is not an inbuilt function in excel. You need to create it in VB
Editor (can be a module specific to a file or can be created in
Personal.xls). Once that function is created the same can be called whenever
required.

In case you need the code for the colorindex do let me know I shall forward
u the same.

Regards
Raj

"Nell Fahey" wrote:

The above function is not set up in Excel. Do I need to set it up or can I
copy it in?
--
All help appreciated.

The code here might be what you are referring to
http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

"Nell Fahey" wrote in message
...
The above function is not set up in Excel. Do I need to set it up or can
I
copy it in?
--
All help appreciated.

Thanks. That's what I needed to know.

NF
--
All help appreciated.


"Raj" wrote:

Hi Nell

Colorindex is not an inbuilt function in excel. You need to create it in VB
Editor (can be a module specific to a file or can be created in
Personal.xls). Once that function is created the same can be called whenever
required.

In case you need the code for the colorindex do let me know I shall forward
u the same.

Regards
Raj

"Nell Fahey" wrote:

The above function is not set up in Excel. Do I need to set it up or can I
copy it in?
--
All help appreciated.