ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,224
- Office Version
- 2007
- Platform
- Windows
Hi,
I had two separate workheets with a template on each.
I would then go to the relevant worksheet & print the page.
Not sure of the correct name but i had to select the area i would like to print,this was saved for the future prints and i see a dotted line showing this.
Ive now put both templates on one worksheet.
I am now not able to select & keep 2 print areas.
I would like to use two command buttons for the printing of the template.
How would the code be writing if say the print are is A1:K23
I will then copy the code for the other template but will alter the range for Q1:AA23
I had two separate workheets with a template on each.
I would then go to the relevant worksheet & print the page.
Not sure of the correct name but i had to select the area i would like to print,this was saved for the future prints and i see a dotted line showing this.
Ive now put both templates on one worksheet.
I am now not able to select & keep 2 print areas.
I would like to use two command buttons for the printing of the template.
How would the code be writing if say the print are is A1:K23
I will then copy the code for the other template but will alter the range for Q1:AA23