Ensuring a Cell in Print Preview DOES Print

[Bob Barnes]

We're running automation from Access to Excel which includes a "long text"
(maybe 150 characters) that populates a cell.

In Print Preview, that particular cell is seen, but it doesn't Print,
unless...

1 - Printing the Charts in black-&-white (NO color) DOES Print the cell.

2 - Manually doing a "Merge and Center" (automation to a group of "Merge and
Center" cells [a single row of 4 cells]) on the cell DOES Print the cell.

So..the automation populates the leftmost cell in the 4 cells (which do NOT
have a "Merge and Center"). But, to print, these 4 cells must have a "Merge
and Center" applied before Printing.

Suggestions? TIA - Bob

 

[Jacob Skaria]

Check out format cells>Alignment>Word wrap

 

[Bob Barnes]

Jacob,

The "problem" w/ that is that it makes the 11 x 17 Print too big...however,
Hmmm, if we make the Fonts smaller, it should work.

Thank you, Bob

Check out format cells>Alignment>Word wrap
--
If this post helps click Yes
---------------
Jacob Skaria

We're running automation from Access to Excel which includes a "long text"
(maybe 150 characters) that populates a cell.

In Print Preview, that particular cell is seen, but it doesn't Print,
unless...

1 - Printing the Charts in black-&-white (NO color) DOES Print the cell.

2 - Manually doing a "Merge and Center" (automation to a group of "Merge and
Center" cells [a single row of 4 cells]) on the cell DOES Print the cell.

So..the automation populates the leftmost cell in the 4 cells (which do NOT
have a "Merge and Center"). But, to print, these 4 cells must have a "Merge
and Center" applied before Printing.

Suggestions? TIA - Bob