mod error in VBA

[geebee]

hi,

i have the following:

R = Evaluate("mod(x,2)")

but i am getting a type mismatch error.

im not sure how to fix this..

thanks in advance,
geebee

 

[Jim Thomlinson]

What is x? Assuming it is a variable then you can not just have it in the
string. Try this...

R = Evaluate("mod(" & x & ",2)")

 

[Dave Peterson]

VBA has its own Mod function, too.

hi,

i have the following:

R = Evaluate("mod(x,2)")

but i am getting a type mismatch error.

im not sure how to fix this..

thanks in advance,
geebee

 

[Bob Phillips]

.... but it works differently to the Excel one.

 

[Dave Peterson]

Yep.

(I don't have a guess if that's important to the OP, though.)