Function MOD

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

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
 
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.
 
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.
 
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.
 
Dave
But Alan Beban solved the problem (same solution as yours) in the next thread.
Click to expand...

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

Dick
 
Dick said:
Dave



thread.


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

Dick
Click to expand...
Well, they don't always show up at the time indicated.

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