:I think
you can define it in a Class Module, but I've never done that.

You can't do that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"cush" wrote in message
...
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