| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I call VBA subs from different spreadsheet from code behind form? | Excel Discussion (Misc queries) | |||
| looking for an excel spreadsheet for call center | Excel Discussion (Misc queries) | |||
| Email alert to call or view a line in a spreadsheet | Excel Worksheet Functions | |||
| how i can call the function | Excel Worksheet Functions | |||
| call function | Excel Programming | |||
![Harold[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
