using UDF question

[JMay]

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

 

[Adam Kroger]

how do you use an UDF? I put the "program" into the VBE in ThisWorkbook.
Located & inserted the function from the <shift>F8 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

 

[Adam Kroger]

Worked perfect, thanks

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