Your assistance is greatly appreciated for this problem.
For print purposes (and for reasons of easily creating contiguous print output) I have created a summary worksheet that pulls together data from many areas within in a large, complex workbook. This summary sheet is a temporary "scratch" sheet created from a template, is populated with variable-length data, and is then destroyed after the user prints the sheet. I have done this so that I can easily pre-format individual cells (for height, width, font, word-wrap within a cell, etc.). Some cells may have up to a paragraph of explanatory text based on decisions the user has made in other parts of the workbook. These same cells may also have only several words if the user has made a different pre-selection.
And this is my problem. Ideally, I would like to have the cells resize dynamically to accommodate just the text they contain, so that the final print output looks clean and there is no excessive white space. Right now, I have to pre-fix and pre-format cells to the longest possible text entry.
I would rather not code VBA to instantiate Word from this Excel spreadsheet, even though I know this problem could be solved by running a simple merge function within Word. Is there any way to dynamically resize an Excel cell to accommodate variable length text?