I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie

hi
you don't run functions like you run a macro. you install them.
each fomula in excel has a function behind it. type the fomula, the
functions runs and return the results to the formula.
the functions at the xldynamics site only return the color index numbers.
you use the formula at that site to return the results of count, sum and do
other stuff.

I understand this is all built into 2007. haven't use it yet.

regards
FSt1

"davethewelder" wrote:

I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie

Thanks for that. I look forward to using 2007, at present we are using 2002.
Do you install the function on a new Module?

Cheers,

Davie

"FSt1" wrote:

hi
you don't run functions like you run a macro. you install them.
each fomula in excel has a function behind it. type the fomula, the
functions runs and return the results to the formula.
the functions at the xldynamics site only return the color index numbers.
you use the formula at that site to return the results of count, sum and do
other stuff.

I understand this is all built into 2007. haven't use it yet.

regards
FSt1

"davethewelder" wrote:

I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie

hi
yes. any standard module will do. it will show up in your list of formulas
also.

regards
FSt1

"davethewelder" wrote:

Thanks for that. I look forward to using 2007, at present we are using 2002.
Do you install the function on a new Module?

Cheers,

Davie

"FSt1" wrote:

hi
you don't run functions like you run a macro. you install them.
each fomula in excel has a function behind it. type the fomula, the
functions runs and return the results to the formula.
the functions at the xldynamics site only return the color index numbers.
you use the formula at that site to return the results of count, sum and do
other stuff.

I understand this is all built into 2007. haven't use it yet.

regards
FSt1

"davethewelder" wrote:

I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie

after thought...
the function will only be available in the workbook that has the function.
if you want it available to all workbook, put the function in a personal.xls
workbook and save it to the xl start folder. the xlstart folder is located in
the xl program folder. i'm using xp and it is at....
c:\program files\microsoft office\office10\xlstart
your's i think is different.
the personal.xls should be hiden and opens in the background when xl starts.
all custom fuctions and macro in the personal.xls will then be available to
all files.

regards
FSt1

"FSt1" wrote:

hi
yes. any standard module will do. it will show up in your list of formulas
also.

regards
FSt1

"davethewelder" wrote:

Thanks for that. I look forward to using 2007, at present we are using 2002.
Do you install the function on a new Module?

Cheers,

Davie

"FSt1" wrote:

hi
you don't run functions like you run a macro. you install them.
each fomula in excel has a function behind it. type the fomula, the
functions runs and return the results to the formula.
the functions at the xldynamics site only return the color index numbers.
you use the formula at that site to return the results of count, sum and do
other stuff.

I understand this is all built into 2007. haven't use it yet.

regards
FSt1

"davethewelder" wrote:

I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie

Customary folder for XLSTART is

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

If you create a personal Macro Workbook by recording a macro, that is the path
Excel uses for Personal.xls


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 10:58:01 -0800, FSt1 wrote:

after thought...
the function will only be available in the workbook that has the function.
if you want it available to all workbook, put the function in a personal.xls
workbook and save it to the xl start folder. the xlstart folder is located in
the xl program folder. i'm using xp and it is at....
c:\program files\microsoft office\office10\xlstart
your's i think is different.
the personal.xls should be hiden and opens in the background when xl starts.
all custom fuctions and macro in the personal.xls will then be available to
all files.

regards
FSt1

"FSt1" wrote:

hi
yes. any standard module will do. it will show up in your list of formulas
also.

regards
FSt1

"davethewelder" wrote:

Thanks for that. I look forward to using 2007, at present we are using 2002.
Do you install the function on a new Module?

Cheers,

Davie

"FSt1" wrote:

hi
you don't run functions like you run a macro. you install them.
each fomula in excel has a function behind it. type the fomula, the
functions runs and return the results to the formula.
the functions at the xldynamics site only return the color index numbers.
you use the formula at that site to return the results of count, sum and do
other stuff.

I understand this is all built into 2007. haven't use it yet.

regards
FSt1

"davethewelder" wrote:

I have looked at the posts on the site and I have tried the formulae and
Functions form the xlDynamic - Colour Counter but to no avail. If I copy the
formula into the spreadsheet I get the #NAME error.
If I copy the Function code into the VB editor I cannot get it to run. Am I
missing something?


Cheers

Davie