I have done everything that the help has given me. I need to print out a
spreadsheet that has 31 tabs. I want to change the original print area to a
new one on all the sheets. I can't seem to accomplish this. I have tried to
right click the tabs and choose select (group) I have tried to name ranges
with the ='day1:day31'!a1:j48. This only works on 1 or two pages. Is there
a way to remove an existing print range and replace it with a new one in an
entire workbook? This would be helpful as I need to print out the daily
production for 2 1/2 years (1000 sheets of paper).