Print Macro with a 1004 Run Time Error

I Recorded a macro that would allow me to print the charts in sheet 2, but upon running the macro, I got a 1004 runtime error.

I looked at the debugging code and saw the last line was the problem.

How do I fix it?

Code from VBA Editor:

Please Login or Register  to view this content.

Excel Macro Help 1.xlsm

You need to add code tags to your code sample above.

Assuming you do that, remove all the " Application.PrintCommunication = True/False" statements.

My understanding is that it is supposed to stop constant chatter with the printer to speed things up but I'm not sure it works ... or which version of Excel it should work in. Anyway, ditch it. And get rid of all the lines where you are accepting defaults for things you never change. For example, if you have never set the footers, get rid of all the xxxFooter.Text statements. That will make it quicker.

Regards, TMS

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Sorry TMS. I didnt refresh (again).

@Arlette: no worries ...but you've only tagged the first line of code.

@derivative_x: that option came in in 2010 and your profile says 2007 (it doesn't work for me on 2007, fair enough).

I believe that "IgnorePrintAreas" is incompatible with printing a selection, so just remove it.

Regards, TMS