Call Function in Different Spreadsheet

H

Harold

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?
 
B

Bernie Deitrick

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
 
Top