How can a UDF be called from a formula?

G

GuyH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping integers to strings 6
UDF from Add-In returning #NAME 0
Creating a UDF to search a cell's formula 13
Creating UDF prompts (XL 2007) 3
Losing Data From Formulas When Cell Variable Changes 6
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why? 4
UDF Looks for Named Range Not Function 2
Can UDF modify worksheet(s)? 5

Top