| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mod error in VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mod error in VBA
VBA has its own Mod function, too.
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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mod error in VBA
.... but it works differently to the Excel one.
-- __________________________________ HTH Bob "Dave Peterson" wrote in message ... VBA has its own Mod function, too. 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mod error in VBA
Yep.
(I don't have a guess if that's important to the OP, though.) Bob Phillips wrote: ... but it works differently to the Excel one. -- __________________________________ HTH Bob "Dave Peterson" wrote in message ... VBA has its own Mod function, too. 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error handling error # 1004 Run-time error | Excel Programming | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Linear Mode
