ClimoC
Well-known Member
- Joined
- Aug 21, 2009
- Messages
- 584
I have been stumped with this, mainly because of the slightly annoyingly tight requirements :s
Essentially what I'm trying to do is combine PrintTitleRows, PrintTitleColumns, Custom Print areas, and Scale to fit page.
PrintTitleRows needs to stay at 86:91
PrintTitleColumns needs to stay as A:A
The Custom print areas I will set by measuring the varying table sizes for the number of pixels they will take up, and then picking a suitable compromise for each sheet. (To briefly explain why I'm doing it this way - I have 7 tables/grids like calendars, Monday to Sunday, with dates running on the x axis. I roughly want between 2 and 4 'weekday' tables/grids per page - depending on the height of each table)
800-1000 pixels per page seems to be a good size (so will reverse-find the number of rows this would be in each instance), and 16 columns seems to be a good width (all the standard pixel width)
An alternative I have considered was to figure out the ranges to select (that's not the hard part), and then save the selection as a pdf... but that has two problems. - 1) Any white space around the range stays as part of the pdf 'image', and I can't keep the titlerows and titlecolumns
Anyone have any suggestions? (vba'ing here In should add) No matter how fidgety or hashed?
Essentially what I'm trying to do is combine PrintTitleRows, PrintTitleColumns, Custom Print areas, and Scale to fit page.
PrintTitleRows needs to stay at 86:91
PrintTitleColumns needs to stay as A:A
The Custom print areas I will set by measuring the varying table sizes for the number of pixels they will take up, and then picking a suitable compromise for each sheet. (To briefly explain why I'm doing it this way - I have 7 tables/grids like calendars, Monday to Sunday, with dates running on the x axis. I roughly want between 2 and 4 'weekday' tables/grids per page - depending on the height of each table)
800-1000 pixels per page seems to be a good size (so will reverse-find the number of rows this would be in each instance), and 16 columns seems to be a good width (all the standard pixel width)
An alternative I have considered was to figure out the ranges to select (that's not the hard part), and then save the selection as a pdf... but that has two problems. - 1) Any white space around the range stays as part of the pdf 'image', and I can't keep the titlerows and titlecolumns
Anyone have any suggestions? (vba'ing here In should add) No matter how fidgety or hashed?
