staticbob
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,079
Guys,
I need code that will set the print range (Pages x to x) for sheets with a certain name. These sheets will always be at the end of the workbook, there could be one, there could be 60.
If the sheet name starts with "SubCon Enquiry" then I want to include it in the print range. I could have "SubCon Enquiry 01" to "SubCon Enquiry 58", this should be my print range ?
Any starters please,
Thanks
Bob
I need code that will set the print range (Pages x to x) for sheets with a certain name. These sheets will always be at the end of the workbook, there could be one, there could be 60.
If the sheet name starts with "SubCon Enquiry" then I want to include it in the print range. I could have "SubCon Enquiry 01" to "SubCon Enquiry 58", this should be my print range ?
Any starters please,
Thanks
Bob