software

How can I setup an function which I can view and use when I click “insert
function” or as a system?
e.g.
Public Function NewNumber(IDRange As Range)
NewNumber = IDRange.Cells(1, 1).Value 1
End Function
I want the function NewNumber can be as part the list functions when click
“insert function” (“fx”)It will be, in the User Defined category.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;NYExcelquot; gt; wrote in message
...
gt; How can I setup an function which I can view and use when I click quot;insert
gt; functionquot; or as a system?
gt; e.g.
gt; Public Function NewNumber(IDRange As Range)
gt; NewNumber = IDRange.Cells(1, 1).Value 1
gt; End Function
gt; I want the function NewNumber can be as part the list functions when click
gt; quot;insert functionquot; (quot;fxquot;)
gt;