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

S

Smithy

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

Top