Wrap text with Merged cells

[kalwijro]

Hello there,

I want to place a large amount of text into some merged cells in an Excel sheet, and I want the text in these cells to continue on the next line (increasing the row-height) if it is to long for one line.

If I use "Wrap text" in "Format Cells" for a single cell it works fine, but if I use it in combination with "Merge cells" it just merged the cells.

Does anybody know what I should do?

Thanks in advance
RK

 

[xlbo]

The height of the cell won't auto increase - liklihood is that the text is wrapped, you just need to drag the bottom border down some.
HTH
Geoff

 

[kalwijro]

Thanks Geoff,

But the problem is that I fill the sheet from a VB exe and I want the row automaticly to increase. I don't know how much text the user will put in the merged cells.

I guess I have to determine the number of characters in the text and divide it by an estimated number of characters in one line, giving me the number of lines the text will use.

Robert

 

[macbone2]

I've seen this before. i think if you format the range of cells BEFORE you run the macro, or as the early lines of code, you'll possibly find that the cell range expands to fit.

Geoff