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.
Bookmarks