Hi,
I got this code
LastSheet = Sheets.Count
Sheets("Template").Copy After:=Sheets(LastSheet)
Copies All template sheet and creates sheet and paste the content.
I cannot work out how to do the same but copy only a range of cells in Template?
I got this code
LastSheet = Sheets.Count
Sheets("Template").Copy After:=Sheets(LastSheet)
Copies All template sheet and creates sheet and paste the content.
I cannot work out how to do the same but copy only a range of cells in Template?