Hi all

I suspect that this is a really simple easy question but it is annoying
with the lack of information available......

I have created a function called

weekno(ipdata as date) as integer

and have put it in -thisworkbook- on the vba editor.....

Firstly is this the correct place to put functions or do I need a
module?
Secondly is I go to any of the sheets and in a cell put =weekno(K4) for
example, I get #Name? - how do I make it reference -thisworkbook- to
tell it that the function is located there?

Any help is appreciated.


--
-=Merovingian=-


------------------------------------------------------------------------
-=Merovingian=-'s Profile: http://www.excelforum.com/member.php...o&userid=28443
View this thread: http://www.excelforum.com/showthread...hreadid=480421