Calling a function in another project from within a cell formula

  • Thread starter Thread starter Ellis Horowitz
  • Start date Start date
E

Ellis Horowitz

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
 
Hi, Ellis!

Try coding the formula like this:

=personal.xls!your_function(some_parameter)

The personal.xls workbook must be open for this to work.

Regards,
Wes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
UDF Looks for Named Range Not Function 2
calling a user defined add-in 5
Create VBA Function/Sub programatically within Excel VBA 2
Sum Function When Formula Produces #N/A 2
Using user-defined functions in cells 1
Cell address of function call 1
Problem with VBA Functions that use a DefinedRange as parameter 6

Back
Top