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.
Bookmarks