Call Function in Different Spreadsheet

  • Thread starter Thread starter Harold
  • Start date Start date
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?
 
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
 
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

Comparing data (conditionally) between two spreadsheets 3
Excel spreadsheet to Word document 1
Excel shortcut options 0
Moving Macros to the Application Level 2
Excel Excel spreadsheets opening at top instead of bottom. 4
Data in columns 1
Excel Spreadsheets keep moving 0
2 spreadsheets - populating one by multiplys of another 3

Back
Top