Remove it from the Thisworkbook module and put it in a Standard module. then
retry..

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
how do you use an UDF? I put the "program" into the VBE in ThisWorkbook.
Located & inserted the function from the <shiftF8 dialog box. But excell
wouldn't recognize the function. What am I doing wrong? The UDFs I am
trying to use are UseSameAS and UseFormula2 from
http://www.mvps.org/dmcritchie/excel/formula.htm