Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 On Mon, 25 Feb 2008 09:26:05 -0800, davethewelder wrote: 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" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
Finally got it to run, please excuse my stupidity.
Thanks for all your help. Davie "Gord Dibben" wrote: 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 On Mon, 25 Feb 2008 09:26:05 -0800, davethewelder wrote: 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" wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
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 On Thu, 28 Feb 2008 02:15:00 -0800, davethewelder wrote: Finally got it to run, please excuse my stupidity. Thanks for all your help. Davie "Gord Dibben" wrote: 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 On Mon, 25 Feb 2008 09:26:05 -0800, davethewelder wrote: 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" wrote: 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with specific Colours
On reflection I agree. Thanks for your help.
Davie "Gord Dibben" wrote: 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 On Thu, 28 Feb 2008 02:15:00 -0800, davethewelder wrote: Finally got it to run, please excuse my stupidity. Thanks for all your help. Davie "Gord Dibben" wrote: 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 On Mon, 25 Feb 2008 09:26:05 -0800, davethewelder wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting specific formatted cells | Excel Discussion (Misc queries) | |||
counting cells that contain a specific value | New Users to Excel | |||
Counting cells not containing specific text | Excel Worksheet Functions | |||
Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) |