View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jurassien Jurassien is offline
external usenet poster
 
Posts: 24
Default 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,