Thanks again - I originally placed it in Sheet1 object instead of a New
Module
P.S. I read your note for listing User Defined Functions, but I don't know
how to "see" the Function Wizard list - can you help me even more?
Thanks
"Frank Kabel" wrote in message
...
Hi
where did you put this code?. It has to go in a standard module (see
the link I provided to you)
--
Regards
Frank Kabel
Frankfurt, Germany
"David Laub" schrieb im Newsbeitrag
...
When I try this, I get a "Invalid Name' error in Excel - i can use
built in
function and named cells fine
Is there some sort of subtle scoping/fully qualified name" issue
"Frank Kabel" wrote in message
...
Hi
use a macro like
public function my_function()
my_function=1234
end function
and in a cell type:
=MY_FUNCTION()
See: http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Regards
Frank Kabel
Frankfurt, Germany
"David Laub" schrieb im Newsbeitrag
...
Can I use a VBA function I write myself in a formula? It appears
to
be
impossibe...
Thanks
David Laub