|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 22nd, 2009, 03:38 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Colors on a worksheet
At work the formula in a cell is: =COUNTCOLOR(B5:AF5,12,FALSE)
At work it is a macro that works How come it does not work or ask me to enable macros when sent via email? and Is there a formula without a macro to enable this function to work, when I am away from work? 
|
|
#2
August 22nd, 2009, 06:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Colors on a worksheet
hi
i don't think it's a macro. i think it's a user defined function from this website..... http://cpearson.com/excel/colors.htm How come it does not work or ask me to enable macros when sent via email? your udf may be in a custom add-in. this is done so that the custom udf will be available to all workbooks that you open. the add-in opens when you open excel and is hidden. in order to get the color formula to work, you would have to add the custom udf to the workbooks you e-mail. but without seeing your setup, i am only guessing that you may have an add-in. Is there a formula without a macro to enable this function to work, when I am away from work? no. Excel provides no support in worksheet functions for working with colors. you must use the custom udf. see the site above for more info. regards FSt1 "Loadmaster" wrote: At work the formula in a cell is: =COUNTCOLOR(B5:AF5,12,FALSE) At work it is a macro that works How come it does not work or ask me to enable macros when sent via email? and Is there a formula without a macro to enable this function to work, when I am away from work?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
