further to my post about printing with merged cells, i.e., ensuring that printouts do not split merged cells contents between pages ...
The code I developed works well as long as the row heights are sufficient to accomodate the contents of the relevant cells. So, my code initially "autofits" the target rows. But this does not work all the time. I have noticed a similar inconsistency when I use the manual autofit. How does autofit impact screen display vs printed output?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
In my experience, Excel is pretty poor if you're looking for a "high quality" formatted output. You may need to copy it into Word and sort it out in a table there.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Really high quality is not my goal, but I would like to format things so I make best use of paper (the output is 40+ Pages of 11x17). Interesting that you would suggest copying the content to Word. This actually started out as a Word table and was a mess to work with and print out. It is an order of magnitude easier to do in Excel.Originally Posted by mdmackillop
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Posting Permissions
Reply With Quote