SumByColor Stopped Working

[Pattylb]

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

 

[Dave]

Hi Pat,
Any chance of seeing a copy of the VBA code, and knowing what sort of data
it's working on?
Dave.

 

[Gord Dibben]

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