View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default mod error in VBA

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)")
--
HTH...

Jim Thomlinson


"geebee" wrote:

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