Calling a function in another project from within a cell formula
Hi All,
I am running into an interesting problem and I was hoping that there
was an easy solution. I have a personal.xls spreadsheet that contains
a set of functions and subroutines. I have created a function in that
spreadsheet that I want to use across moany other spreadsheets. When
I try to use it in a formula within a cell, I get back #name? unless
the function is defined within the project specific to the
spreadsheet. What am I doing wrong here?
Thanks in advanc for any help.
Ellis
|