Gord Dibben wrote on 7/7/2011 :
There is a limit of 32.767 characters in a cell but............there is a
limit
to number of characters in a cell that will be visible or can be
printed............1024 characters at standard 10pt font.

Excel has trouble with a text-formatted cell when number of characters is
between 255 and 1024.

The fix for the ######### is to change format to General.

Yeah, I use an adjacent cell to the Print_Area to count LEN() of
contents. Since the sheets I use are templates I use CF to flag any
that exceed 255 characters because that's the limit I go for copying.
Non-template sheets may go closer to the 1024 limit if need be. And
yes, I use General format unless the paragraphs/lines are numbered in a
separate cell.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc