ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can a UDF be called from a formula? (https://www.excelbanter.com/excel-worksheet-functions/6573-how-can-udf-called-formula.html)

GuyH

How can a UDF be called from a formula?
 

Well, I found my answer myself:
Rather than trying to insert your UDF in an Excel formula (it won't be
recognized by Excel then, even if the function selection wizard does),
insert your UDF first in the cell using the wizard, and then build the
rest of the formula, writing or copying it directly in the cell. Simple
and effective, but not documented, yet...


--
GuyH
------------------------------------------------------------------------
GuyH's Profile: http://www.excelforum.com/member.php...o&userid=16549
View this thread: http://www.excelforum.com/showthread...hreadid=314050



All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com