Counting Cells with specific Colours

[davethewelder]

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

 

[FSt1]

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]

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]

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

regards
FSt1

 

[FSt1]

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

 

[Gord Dibben]

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

 

[davethewelder]

Hi, I have copied and pasted the code from the website into a new Module in
the Visual Basic Editor but I cannot get it to run. Is there something I
have to add to the code?

Thanks for your time.

Davie

 

[Gord Dibben]

As was pointed out in an earlier reply by FSt1, you do not "run" the function
code.

The code is placed into a module in your workbook as you have done.

Then it is used the same as any function.........in cell.

=function(cellref) where "function" is the name of whatever function you are
using from Bob's site.

If you placed the function code into your Personal.xls then you must enter as

=Personal.xls!function(cellref)


Gord

 

[davethewelder]

Finally got it to run, please excuse my stupidity.
Thanks for all your help.

Davie

 

[Gord Dibben]

Good to hear.

Not knowing how to do something new should never be called "stupidity" IMO.

Not knowing after doing it many times may indicate a little bit of slowness or
just a short attention span<g>


Gord

 

[davethewelder]

On reflection I agree. Thanks for your help.

Davie