summing by color
Gord,
So, if I get this correctly, you're saying that we can place the UDF's-- in
general-- in an XLAM workbook, and then add them to our add-in lists, and
access them through that?
"Gord Dibben" wrote:
Or put the functions in a new workbook and save as an Add-in.
Load through ToolsAdd-ins and you won't have to preface the UDF with the
filename.
=SumByColor(A1:A10) will suffice.
Gord Dibben MS Excel MVP
On Mon, 10 Dec 2007 09:44:00 -0800, SteveDB1
wrote:
April,
with this function you need to use the following "preface" to access the
macro.
in your worksheet cell write hte following:
=worksheetname!sumbycolor(range,colornumber,... )
Part of hte problem you've encountered is that you're accessing a function
that's stored in another workbook, and it does not call to that workbook
UNLESS you state it.
I place all of my macros in a single workbook-- personal.xlsb, so when I
call to that function I write hte following:
=personal.xlsb!SumByColor(.......)
It'll work if you choose that.
Best.
"april" wrote:
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
|