Pasteing large amount of text to Excel merged cell

O

outsol

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Fixing text wrap in merged cells 1
Text in merged cells is spilling over 3
Text Running Out of Cell 1
Merged cell text does not wrap 1
trying to automatic fit large amount of text in cell 1
Why only part of the text is merged from excel cell into word? 6
How do I get the a large amount of text to show in merged cell? 2

Top