View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ellis Horowitz Ellis Horowitz is offline
external usenet poster
 
Posts: 4
Default 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