Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumByColor Stopped Working
I have been using this formula/function for over one year. All of a sudden,
it's starting to give me #NAME errors. I deleted the VBA, re-pasted it, tried F9 and the combinations of F9, tried F2 and enter, etc. My old files with this function open okay, but if I make any changes, I suddenly get the #NAME error. I have Excel 2003 and have had it for a while. Thanks for any help. Pat |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumByColor Stopped Working
Hi Pat,
Any chance of seeing a copy of the VBA code, and knowing what sort of data it's working on? Dave. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumByColor Stopped Working
Post a formula you are using.
Same as this one which sums cells with background of Red =sumbycolor(A1:A18,3,FALSE) Where is the Function located? In same workbook or maybe Personal.xls? Maybe you need =Personal.xls!sumbycolor(A1:A18,3,FALSE) Gord Dibben MS Excel MVP On Wed, 9 Apr 2008 09:26:00 -0700, Pattylb wrote: I have been using this formula/function for over one year. All of a sudden, it's starting to give me #NAME errors. I deleted the VBA, re-pasted it, tried F9 and the combinations of F9, tried F2 and enter, etc. My old files with this function open okay, but if I make any changes, I suddenly get the #NAME error. I have Excel 2003 and have had it for a while. Thanks for any help. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboardshortcuts stopped working | Excel Discussion (Misc queries) | |||
Formulas Stopped Working | Excel Discussion (Misc queries) | |||
Web query has stopped working... | Excel Discussion (Misc queries) | |||
Subtotal has stopped working | Excel Worksheet Functions | |||
VB Stopped Working | Excel Worksheet Functions |