View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default 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