"JE McGimpsey" wrote:

And if you set a breakpoint in the first line of your function and
manually initiate a calculation, where does the error occur in your
function code?

It doesn't! That's what's confusing. The function is not getting called at
all.

Maury





In article ,
Maury Markowitz wrote:

I have a function in VBA that we call all over the place in our code. It
looks like...

Function GetFld(Fieldname As String, secID As String)

I am trying to call it from a cell in Excel. So I typed...

=getfld("pricecode",D5)

That returns "#value". I assume I'd making some noob mistake, what is it?

Maury