Call Function in Different Spreadsheet
 

I have a 2 spreadsheets (A and B). Both are open, I want
to call a function I created in B from Spreadsheet A. Is
this possible in Excel?

Call Function in Different Spreadsheet
 

Harold,

Set a reference to Spreadsheet B (through the VBE - Tools, References, then
find the project) and then you'll be able to simply use the functions as if
they were in Spreadsheet A.

HTH,
Bernie
MS Excel MVP

"Harold" wrote in message
...
I have a 2 spreadsheets (A and B). Both are open, I want
to call a function I created in B from Spreadsheet A. Is
this possible in Excel?