I am using VBA to create sheets from a template and then creating named ranges scoped for each sheet created. Each named range corresponds to the print area that would be a page when printed. I also use the sheet index to create a string that is unique to each sheet for the named ranges so they are easier to troubleshoot since there could be up to 2000 sheets.