ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a maximum number of characters allowed in a cell? (https://www.excelbanter.com/excel-programming/416187-there-maximum-number-characters-allowed-cell.html)

RyanH

Is there a maximum number of characters allowed in a cell?
 
I have 6 cells that are merged in 1 Row (Range("C29:H29")). I have 1106
characters in the merged cell. For some reason I see all the text in the
cell in Normal View, but when it prints it cuts off the last 40 characters.,
why? The Print Preview also cuts off the last 40 characters, why?

Here is the formatting of the merged cells:
Horizontal - Justified
Vertical - Center
Wrap Text - True
Number - Text
Size - 9
Font - Arial
Row Height - 108
--
Cheers,
Ryan

RyanH

Is there a maximum number of characters allowed in a cell?
 
I forgot. I have about 10 words in the merged cells that are bold, the rest
are regular text. I can print all the text if there are no bold letters.
--
Cheers,
Ryan


"RyanH" wrote:

I have 6 cells that are merged in 1 Row (Range("C29:H29")). I have 1106
characters in the merged cell. For some reason I see all the text in the
cell in Normal View, but when it prints it cuts off the last 40 characters.,
why? The Print Preview also cuts off the last 40 characters, why?

Here is the formatting of the merged cells:
Horizontal - Justified
Vertical - Center
Wrap Text - True
Number - Text
Size - 9
Font - Arial
Row Height - 108
--
Cheers,
Ryan



All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com