I have the formula to print range of pages but I need to vary that dynamically depending on number of pages. I am running a sport tournament and want to printout page 1 alone then print page 2 thru ?
Here is the command I found by google:
[code]Worksheets.PrintOut from:=1, to:=1[\code] oops - this code didn't compile
I'd like to run the macro with the page 1 values hard coded just as it shows, but then would like to use same command and print pages 2 thru ??.
** The last page will be in range 2 thru 11.
Can I substitute a variable for the last page value?
Since the command I found on Google didn't work can anyone help with issuing 2 printout commands
One to print page 1 only
Then 1 to print page 2 thru ???
I need this so I can get participants on page 1 started as soon as possible due to limited time available.
I won't need to issue two print commands if I can print in the order first page to last (variable) page.
Thanks for your help.
Bookmarks