How do i wrap text in a merged cell in excell?

G

Guest

i wish to merge some cells using VBA, add text then wrap the text so the
merged cell will get taller if the text wont fit in it. only the wrapping
isnt working. i have the row height set to auto and it works when the cells
are not merged. it is important that i merge them
 
L

Lonnie M.

Smithy,
I played around with this, and you are right auto fit doesn't work :(
I recommend manually adjusting '.RowHeight' based on the length of the
cell's value; I.E. Len(Cell(1,1)).
This will be a bit of trial and error based on the column widths
involved.

HTH, Lonnie
 

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

wrap text in merge cells 7
Auto fit wrapped and merged cells in entire worksheet Options 0
Is there a maximum number of characters allowed in a cell? 1
Row Height-expand if text wraps in a cell 12
Text wrapping on merged cell 4
Wrapping multiline text in merged cells 1
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
Strip out certain rows that have merged cells 2

Top