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,