I have a template file where a number of different size worksheets can be copied out to create a 'client' copy (basically everything removed other than the data in a flat file).
When the flat client file is created the PrintTitlteRows range seems to be removed.
I have tried to use the following to put into the client file after it is created
This is applied to every sheet to ensure that they all hold the same range to repeat but when I open the client file, this range is not in any of the output sheets.
I am completely lost as to what is happening here as when I look at the sheets to output when they are in the tempate, this range is specified to repeat.
TIA
When the flat client file is created the PrintTitlteRows range seems to be removed.
I have tried to use the following to put into the client file after it is created
Code:
Application.PrintCommunication = False
wsSheet.PageSetup.PrintTitleRows = "$3:$5"
Application.PrintCommunication = TrueI am completely lost as to what is happening here as when I look at the sheets to output when they are in the tempate, this range is specified to repeat.
TIA
