Printing Pages Via Input Box

[realniceguy5000]

Hi,

I having troubles getting a part of this script to do what I want and was hoping someone could point out what to try.

What I need is when the user is asked to enter the amount of pallets. The number they input is placed into a cell.

Here is the problem.

I'm looking for a way to start at number 1 and work up to the number the user placed in the input box.

For example if the user put 5 in the input box Range("F37") Would read 5 then in range("A37") the number would read 1.
Then the page would print ,the next value in Range("A37") would be 2 ,then print and so on up to 5

So the end result I would have 5 pages that printed with the only differnce being Range("A37") Value being 1,2,3,4,5 .

Can someone help

Thanks as always, Mike


Here is the complete code. Problem is in the pallet code near the bottom.

Please Login or Register  to view this content.

[D_Rennie]

hello.

This may be what you are after

Please Login or Register  to view this content.

cheers

[realniceguy5000]

hello.

This may be what you are after

Please Login or Register  to view this content.

cheers

Thank You for your help. Code works well except this line

Please Login or Register  to view this content.

Where I got an error saying you must enter a number between 1 and something. I change the PrintPage to dNumber as the dNumber was declaired and PrintPage wasn't.

Please Login or Register  to view this content.

I ran the code with the change I made and the worksheet went through the motions of printing but nothing came out of the printer.

I then change the code once again to this.

Please Login or Register  to view this content.

The worksheets printed correctly so far, I hope I'm not missing something changing the code to just that.

Anyway thanks for getting me on the right path...

Mike