Hello people,

im new to using VBA, and im having a rather stupid problem. I am tryin
to write a function that i could use inside the worksheet, e.g. A
=Foo(). I tried
Code
-------------------
Function Foo()
Foo = 42
End Functio
-------------------
and several variations on that theme, but the only effect i'm gettin
is #NAME errors. Does a function have to be registered in some wa
before being used on a sheet? or do i have to use CALL in some way?

Thanks for any help,

Liosa

--
Liosa
-----------------------------------------------------------------------
Liosan's Profile: http://www.excelforum.com/member.php...fo&userid=2629
View this thread: http://www.excelforum.com/showthread.php?threadid=39576