i working spreadsheet going need have 100 identical pages, each numbered accordingly 1-100. there way in excel repeat spreadsheet arbitrary number of times? currently, solution copy/paste contents of page 100 times. avoid if possible, there situations may need 50, 100, or 200 pages printed. of course, copy/paste 200 times, , print necessary pages, file 200 times larger necessary, , not easy work with.
you can use subroutine:
sub printpage(pagenumber integer) activesheet.pagesetup.centerheader = "page " & pagenumber activesheet.printout end sub
Comments
Post a Comment