Thread: Creating Functions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default Creating Functions
Module

--
Don Guillett
SalesAid Software

"-=Merovingian=-"
wrote in message
...

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



Reply With QuoteReply With Quote