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

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.

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