Function MOD

[Microsoft]

I am unable to use the MOD Function within a module. The line gets
highlighted in red and does not offer any comments or hint as to why.

However if I use the function within the spreadsheet I get the desired
results.
I looked at the reference section for any unusual entries but found nothing.

I am using office 2003. There is no problem with the syntax

Many thanks
Bernard

 

[Dave Peterson]

Look for MISSING under Tools|References.

When you have missing references, the line that's marked as an error doesn't
have to be the real problem.

 

[Dick Kusleika]

Bernard

Also note that the MOD worksheet function is not available in VBA because
VBA has its own Mod, whose syntax is

Var1 = Var2 Mod Var3

whereas the worksheet function is

=MOD(Var2,Var3)

So it may be a syntax problem.

 

[Dave Peterson]

I was confused by: "... There is no problem with the syntax"

But Alan Beban solved the problem (same solution as yours) in the next thread.

 

[Dick Kusleika]

Dave

But Alan Beban solved the problem (same solution as yours) in the next thread.

Yeah, I saw that *after* I posted. I don't know how I missed it before.

Dick

 

[Alan Beban]

Dave



thread.


Yeah, I saw that *after* I posted. I don't know how I missed it before.

Dick

Well, they don't always show up at the time indicated.

Alan Beban

 

[Dave Peterson]

And I read in order of posting/thread. So I saw Alan's post within moments of
me hitting the send button.