Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error type mismatch
Hello,
Can anyone help me undertand why I am having this error message " Type mismatch " when I run the second macro (format page to landscape legal within the entire workbook)? Indeed the macro executes what I want, but at the end of the process it displays the error message: Type mismatch. How do I get to fix that? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error type mismatch
When the error occurs, click the "Debug" button in the dialog that displays,
and post here the offending line of code. "Jurassien" wrote in message ... Hello, Can anyone help me undertand why I am having this error message " Type mismatch " when I run the second macro (format page to landscape legal within the entire workbook)? Indeed the macro executes what I want, but at the end of the process it displays the error message: Type mismatch. How do I get to fix that? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error type mismatch
Actually, the only option that I get when the message pops up is either Ok or
Help. "Chip Pearson" wrote: When the error occurs, click the "Debug" button in the dialog that displays, and post here the offending line of code. "Jurassien" wrote in message ... Hello, Can anyone help me undertand why I am having this error message " Type mismatch " when I run the second macro (format page to landscape legal within the entire workbook)? Indeed the macro executes what I want, but at the end of the process it displays the error message: Type mismatch. How do I get to fix that? Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error type mismatch
In fact, I don't even have the abilitity to debug because when I compile
these macros I don't get any error messages. "Chip Pearson" wrote: When the error occurs, click the "Debug" button in the dialog that displays, and post here the offending line of code. "Jurassien" wrote in message ... Hello, Can anyone help me undertand why I am having this error message " Type mismatch " when I run the second macro (format page to landscape legal within the entire workbook)? Indeed the macro executes what I want, but at the end of the process it displays the error message: Type mismatch. How do I get to fix that? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND type mismatch error, but don't see it | Excel Worksheet Functions | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
Type mismatch mysterious error | Excel Discussion (Misc queries) | |||
Visual Basic macro run time error(13) type mismatch | Excel Discussion (Misc queries) | |||
Why type mismatch - R/T error 13 | Excel Discussion (Misc queries) |