| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Table in my VBA User Defined Function
Hi,
I am making a UDF that is an engineering equation. This equation requires looking up data in a set table. I want to be able to use this in several of my spreadsheets, without having to copy the table into each one. Is there a way to incorporate it into my UDF so that it can reference the table or do I have to add a sheet to my personal.xlsb and then do it that way? I want to make this UDF into an add-in so that it is easier to share with collegues. Thanks! Jen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dcount function within user-defined worksheet function | Excel Programming | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| How to access MSSQL table in a user defined function | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
![Jen[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
