Pasteing large amount of text to Excel merged cell
 

My users need to cut and paste from websites and Word docs to an Excel sheet.
I have informed them about the 1024 char limit and the manual ALT+Enter
method of "revealing" the hidden text. I'm hearing soooo many "that's too
time consuming/difficult" complaints that I must automate the text to fit.
this documaent has to be printed and forwarded for approval so we have to
"see" everything. Some pastes even exceed the 409.5 Rowheight limit. Could
VBA code identify lines that exceed the 127 char width of my merged cell and
add a Char(10) or something similar to the ALT+Enter? Can the Font size be
manipulated in code to fit in the merged cells?