finding the function

[axg275]

Hello,

I have a function that i use in excel. I now want to find the function so I can use it in VBA but the problem is that I cant find it where it is. It works in excel but not in the VBA editor. Is there a way to find this function and were it is?

Thanks

 

[Norie]

And this function is?

 

[axg275]

=terp(xval, xvalarray, yvalarray) its a function that does interpalation that someone wrote and i think its sitting in an addin somewhere

 

[Norie]

Well if it's part of an add-in I'm not 100% sure how you could access it in VBA.

I know you can access functions from the Analysis Tool-Pak by setting certain references.

But that's a 'standard' add-in.

 

[mikerickson]

Have you (while in the VBE) used EDIT>FIND "Function terp" to search the VBProject?

 

[RoryA]

If it's in an add-in then you ought to be able to work it out by disabling your installed add-ins one by one until the formula gives you a #NAME error in the worksheet. (I am guessing that the add-in may be protected in which case you can't search through its code)

 

[mikerickson]

Function myWorkAround (xval, xvalarray, yvalarray) as Variant
Rem works only from VBA
    Range("A1").Formula = "=terp(" & xval & "," & xvalarray & "," & yvalarray & ")"
    myWorkAround = Range("A1").Value
End Function

 

[RoryA]

In fact, if you know the add-in is loaded, you can use it within the Evaluate method in code.