how to reference UDF in xla from a cell in xls?
Hello,
I wrote a simple user-defined function in an xla which I
would like to reference from a cell in a workbook. If I
reference the function from inside the respective
workbook, I get the correct response. But if I try to
reference the same function when it resides in the xla I
get #Name? in the cell.
=MyFunc(q3)
returns correctly from within workbook
returns #Name? when function resides in xla
Really appreciate if someone could explain how to
correctly reference the function in the xla from the cell
in the workbook.
Thanks,
Tim
|