So I used the code that I found on here (decided to search before just asking this question) and it works except for one small hiccup.
It sends each page to be printed as it's own file to print, which I think is what it's supposed to do, but when I send it to the network printer it keeps throwing errors at me. It'll resolve the error (I guess) because does print but it's taking about 20 seconds or more between each page. It's better than handwriting all the numbers of the pages in but it's going to take longer than a half hour to print out this 100 page book. Is there a way to combat this or is this more probably an issue with our network/printer?
Thanks!
Printing the same sheet with different page numbers
I have a worksheet in excel that I need to use to create a 100 page logbook. I'm going print the same 1-page worksheet 100 times and bound it. I have to have each page numbered Page 1 of 100, page 2 of 100. . . I'm sure there is a way to do this with some kind of looping print macro, but I'm not...
www.mrexcel.com
It sends each page to be printed as it's own file to print, which I think is what it's supposed to do, but when I send it to the network printer it keeps throwing errors at me. It'll resolve the error (I guess) because does print but it's taking about 20 seconds or more between each page. It's better than handwriting all the numbers of the pages in but it's going to take longer than a half hour to print out this 100 page book. Is there a way to combat this or is this more probably an issue with our network/printer?
Thanks!