I have created a UDF (named Interpolate) to interpolate within a user
selected table. The function works great when the function is created
in a module within the workbook that I call it. Since this seems to be
a handy function to use in the future, I tried to put it in my Personal
workbook so that I can access it in any workbook that I may be working
in. After doing this, I get the error "#NAME" when I try to use it in
another workbook. I declared the function as Public, even though I
think it does that by default. The function requires 3 inputs from the
user (Target, TableRng and ResultCol) and all other variables used to
define Interpolate are internal to the function (and declared with
Dim).

I'm assuming that I'm missing a statement which will allow this formula
to be used within any workbook. This seems like it should be a basic
question but searching this forum hasn't turned up anything yet. If
you have any advice I'd appreciate it. Thanks.


--
mworth01
------------------------------------------------------------------------
mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991
View this thread: http://www.excelforum.com/showthread...hreadid=538657