Hi I Need,

Try replacing :

Public Fuction Comission(MyNum)

with

Public Function Comission(MyNum)

(FuNction)

---
Regards,
Norman


"I need help please" wrote in
message ...
I had a previous post with a few questions. Most of them were answered.
But, I'm still having trouble.

Here's what I have in detail:

In 'Module1'

Public Fuction Comission(MyNum)
Comission = MyNum * 0.6
End Function

(I then hit save, exit VBE, save workbook)
types in =comission(A1)

I get #NAME? error still...

Thanks in advance for your help.