Adding to an existing macro

**dcargill** · 03-26-2012, 08:45 AM

I have the following Macro set up and enabled within Excel 2003, and now wish to add in to print the 3rd page. I have created a Print Copy C208 Page 3 sheet and this is all set up correctly. Any ideas on how to add printing page 3 into the macro below?:

Please Login or Register  to view this content.

**Richard Buttrey** · 03-26-2012, 08:05 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Since you are new here I'll change it for you on this occasion but please remember for the future.

**Richard Buttrey** · 03-26-2012, 08:18 PM

Hi,

Why not just

Please Login or Register  to view this content.

**dcargill** · 03-27-2012, 07:48 AM

Thanks for this! It works a treat! The suggested Macro above is much easier than the one created by someone else several years ago.

Sorry for not posting the code correctly!

**Richard Buttrey** · 03-27-2012, 09:32 AM

Hi,

Merely as an addendum. The code will work fine just as long as no one changes the name of a sheet, e.g. "Print Copy C208 Page 1". It's advisable to avoid hard coding sheet names in VBA code since sods law say that someone will one day change a tab name.

It's always advisable to use the sheet code name rather than the Excel sheet name. Unless someone has changed the code name then they'll be called simply 'Sheet1', 'Sheet2', etc. So a better line of code would be

Sheet1.PrintOut

You'll need to determine of course what are the sheet code names for your three sheets in question.

Regards