View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pattylb Pattylb is offline
external usenet poster
 
Posts: 6
Default 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