Oh yes, if you have a lot of text, I would run it on a few paragraphs at a
time. The text you select gets concatenated into a string variable - which
does have an upper limit on the number of characters it can contain (If I
remember correctly, it's a fairly large number - I've never run into that
problem).

Be sure to back up your work.


"De Tonya" wrote:

Row 1 contains cells that span colums A thru ZZ. The page break is at column
M. Is there a way to automatically wrap the text in cells N1 thru AA1 onto
A2 so that the data fits on one page?