Printin a selection of pages

[pinnerharrow]

I am a long time user of spreadsheet but I am new to EXEL. I am using version 2010.

I have a problem with printing.

I have a Workbook with several Worksheets which are divided into Pages.

I want to print a selection of pages. I know that I can only print a single page or a range of pages but how do I do it?

There are three options in SETTINGS. "Active sheets", "Entire Workbook" and "Selection". None these seem appropriate.

After these option there is a row that shows page numbers that can be edited. Whatever numbers I put into these boxes they are ignored.

How do I get EXEL to act on these entries.

I have tried using Print Areas but you cannot remove a print area to reinstate later because all areas are wiped. Setting them up again is tedious.

Range names can be used to set up these areas but you must be careful to invoke them in the right order becase they seem to be added to the print string on a Last-in-last-out basis not where they appear in the Worksheet.

It would be nice to be able to name Print Areas.

Any comments would be appreciated.

pinnerharrow

[Russell Dawson]

How about creating a macro for each "page". If I understand correctly, you have several areas (Pages) on each worksheet that need to be printed. By creating a macro for each page it will set the print area each time you run each macro. The following sets two separate areas that does this when CtrlA or CtrlB are hit.

Please Login or Register  to view this content.

[royUK]

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

[pinnerharrow]

Thank you Russell for your code. I have tried it and it works.
I have started another thread with a new title to find out why Excel does not respond.

pinnerharrow

[Russell Dawson]

No probs. Remember to mark your questions Solved and rate the answer(s) via the star. Cheers.