how to print a nonconsecutive page

[RDEXCEL2020]

Hi

How to print a non-consecutive page on the second box “Which Page # need to be printed”.

Everything is working good with the code. The only issue is that I can’t or I don’t know how to print the non consecutive page. Let say if I want to print page 2, 3, 5 and 8. I tried 2;3;5;8 did not work.

I am able to print single page and consecutive number. To print a single page let say page 1 then enter 1;1 and if I want to print consecutive page let say page 1 to page 4 then enter 1;4… no problem at all.

Please let me know if its possible to add or fix the code for me to be able to print the non-consecutive page to print from this code:


pNr = Application.InputBox("What Page to Print? seperated by ;", "Printing a Page.", Type:=3)

See attachment.

Thanks.

 

[vletm]

RDEXCEL2020
Why do You duplicate Your thread?

Application input box to print

Hi I have this code and when I get to input box that said "what page you want to print?", then I type 2, 4, 5 but it does not print anything. But if you leave 1 in the box then it print the page 1. Here is the code: This is just the part of the code. pNr = Application.InputBox("What page you...

chandoo.org