Printing Macro

**Jiptastic** · 10-10-2012, 05:45 PM

Macro recorder hasn't let me down too many times before, but I can't get it to record a simple print. This is what it recorded when I printed a page. I selected print selection and center on page. It errors on the last line before end sub. I'm sure the code could be simplified considerably, but why won't it run at all? Any ideas?

Please Login or Register  to view this content.

**xladept** · 10-10-2012, 07:54 PM

Hi again Jiptastic,

Try this:

Please Login or Register  to view this content.

**Jiptastic** · 10-11-2012, 10:48 PM

So I tried it, and it worked perfectly. It's amazing how I can not know anything about what I'm doing. I can use macro recorder and steal your code to fill the gaps, and everyone at works thinks I'm a genius. Thanks a lot!