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