It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

See your earlier duplicate post.

"Rick" wrote in message ...
It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

I just tested your function in a REGULAR module and it worked just fine.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick" wrote in message
...
It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

Don:

What is a "regular" module?


"Don Guillett" wrote in message
...
I just tested your function in a REGULAR module and it worked just fine.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick" wrote in message
...
It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

a regular module is the standard module you get when you use INSERT/MODULE
from the development IDE
-- as apposed to a Class module or code modules behind sheets and so on.
the default name will be Module1, then Module2 and so on.

If your module is named 'Class1' then this is the default name for a Class
Module, which is the wrong place for your code. cut and paste it into a
standard module, delete the class modue and see if that works

"Rick" wrote in message
...
Don:

What is a "regular" module?


"Don Guillett" wrote in message
...
I just tested your function in a REGULAR module and it worked just fine.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick" wrote in message
...
It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

On Mon, 1 Jun 2009 14:52:04 -0700, "Rick" wrote:

It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

What is the name of the Module?
--ron

It's module1. I was trying to use it in the commission column. when I moved
it to another column it worked. go figure. Thanks for all your help!

Rick

"Ron Rosenfeld" wrote in message
...
On Mon, 1 Jun 2009 14:52:04 -0700, "Rick" wrote:

It's a simple function, so far:

Function Commission(Fee)
If Fee = 45 Then Commission = 15 Else Commission = Fee * 0.35
End Function

I've named my ranges. The module is in VBAProject | Modules.

I'm at a loss.

What is the name of the Module?
--ron

On Tue, 2 Jun 2009 10:53:31 -0700, "Rick" wrote:

It's module1. I was trying to use it in the commission column. when I moved
it to another column it worked. go figure. Thanks for all your help!

Rick

Glad you got it working. Although I doubt that moving a properly formed
formula from one column to another would have gotten rid of a #NAME error.
--ron