Macro to print multiple tabs

[jono7gold]

Please could someone help me with this dilema....

I have an sheet called 'Input' and and in cells A1, A2, A3, A4, A5, A6 will each show a value between 1 and 25, I also have 25 additional sheets labelled 1 to 25.

What I would like to do is to create a macro to print the tabs that are shown in cells A1 to A6, hope this makes sense?

Thanks

Jon

[LJMetzger]

Hi jono7gold,

Try this:

Please Login or Register  to view this content.

Lewis

[jono7gold]

Thanks Lewis, that works great. What I would also like if possible is to run a 2nd macro to do the same but save as PDF instead of printing, could you help out with a macro?

Cheers

Jon

[LJMetzger]

Hi Jon,

You'll have to bear with me, because my version of Excel doesn't support creating PDF files. I've tested the following macros the best that I could. If you have a problem, I need to know the exact location of where the problem lies, and exactly what nasty error message Excel generated.

Two macros follow:
a. One creates a separate PDF file for each sheet.
b. The second creates one PDF file. Since I haven't been able to test, it is my understanding from research, that you may have to have a PAGE SEPARATOR (at the end of each sheet).

All the output files will be in the same folder as the file the macros are in.

Please Login or Register  to view this content.

You will also need the following macro that was included in my previous post. If you put these macros in the same file as the macros for the previous post, DO NOT INCLUDE this macro. Having the same macro twice in one Excel file, may cause Excel to LOCK UP.

Please Login or Register  to view this content.

Lewis

[jono7gold]

Thank you Lewis for your time and input, these both work now. Would it be possible to modify the Save as one PDF macro so it opens the Save As dialogue box so I can choose the choose the location and file name?

Many thanks

Jon

[LJMetzger]

Jon,

I'm so happy the previous posts worked, because I wasn't able to test them. Try the following macro which has two supporting macros. The 'LJMFileExists()' macro from the previous post(s) is also needed.

Lewis

New code in red

Please Login or Register  to view this content.

[jono7gold]

Thanks Lewis, that worked perfectly, just exactly what I wanted.

Jon