it's a module in the same workbook
--
aprilshowers


"Bob Phillips" wrote:

Different workbook? It expects it to be in the same workbook.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"april" wrote in message
...
i have copied the code from cpearson.com/excel/colors.htm which allows you
to
sum a range of cells by color. this worked fine in one spreadsheet but
when
i copied the same code to another spreadsheet i get a NAME? error. any
suggestions?

thank you
--
aprilshowers