tmingfai,

You can not define a Function in a cell or range of a spreadsheet. I think
you can define it in a Class Module, but I've never done that.

In a nutshell, the difference between a Macro and a Function is that macros
perform actions while Functions return a value. Functions don't *do*
anything.


"tmingfai" wrote:


What is the difference if I insert my Function in a Module, class Module
and just a spreadsheet (e.g. Sheet1)


--
tmingfai
------------------------------------------------------------------------
tmingfai's Profile: http://www.excelforum.com/member.php...o&userid=34221
View this thread: http://www.excelforum.com/showthread...hreadid=544145