What Page You Want to Print VBA code

[RJ1969]

Hello,

I have about ten pages on my worksheet. I just want Page 1 and 3 to print except the rest of the pages.

Thank you.

Please Login or Register  to view this content.

[jolivanes]

When you say pages, do you mean sheets?
One sheet can have multiple pages.
If you want to print page1 and page 3 of sheet1, hide everything except these pages.
If you want to print 2 sheets, select these sheets and print.
Both no problem with a macro.

Let us know what it is going to be.

[jolivanes]

Read your request again. It is pages of one sheet.
See if this works for you.

Please Login or Register  to view this content.

[RJ1969]

Hi
You can?t add code the page 1 to print only from the originalcode?

maybe from this code?
ActiveSheet.PrintOut copies:=prtQty

thanks

[beyond Excel]

I have about ten pages on my worksheet. I just want Page 1 and 3 to print except the rest of the pages.

Hello. Try with:

Please Login or Register  to view this content.

[jolivanes]

Hardcoded page numbers.

Please Login or Register  to view this content.

[RJ1969]

Hi

With this code:

Please Login or Register  to view this content.

Can you add an input box "What pages you want to print"? That's after the "print Quantity".

So this way, I can decide what pages I want to print instead.

thank you.

[jolivanes]

In Post #1 you say "Page 1 and 3" which excludes Page 2
Is that not true anymore and now you want "From Page1 To Page3"?

[RJ1969]

Hi
That was my previous request that I wanted just to print 1 and 3.
But I am thinking ahead that I wanted to add an input box for what pages to print. Just in case I decided to print page 4 and 9 or whatever pages I desire to print. Is it possible to add an input box in the code below?

Thank you.

Please Login or Register  to view this content.

[beyond Excel]

For example:

Please Login or Register  to view this content.

[RJ1969]

Ok great!

What if i am want or decided to print the entire pages?
Do i put ?all??

[beyond Excel]

What if i am want or decided to print the entire pages? Do i put all??

A little adjustment:

Please Login or Register  to view this content.

[jolivanes]

Like so you mean?

Please Login or Register  to view this content.

[RJ1969]

Perfect! Thank you so much.

[beyond Excel]

Perfect! Thank you so much.

Ok. I hope you can put it to good use.