Macro to make text wrap around

[pincivma]

Hi there

I'm not sure how to do this with a macro or if it is even possible. I have a spreadsheet that I have done a wrap text and merge cells in columns C to E from rows 22 to 382. Now every time that the text goes over the allotted length of columns C to E I have to manually make the row bigger so that I could see the wrapped text. Is there a macro than can make the row a perfect fit every time the text goes passed the allotted width of the merged columns C,D and E? I tried the Excel's Autofit Row Height but that does not work.

Thank you.

 

[AllisterB]

If you are asking if the cells formatted as numbers will merge, the answer is NO. As far as I know, you cannot merge cells that have numbers even if the numbers are formatted as text

Hi

I was asking more like : if there is text and number formats on the same row will the macro change the height of the row if the changes to the text on that row requires a wider or a narrower row.

Allister

 

[pincivma]

Hi

I was asking more like : if there is text and number formats on the same row will the macro change the height of the row if the changes to the text on that row requires a wider or a narrower row.

Allister

Hi Allister
When you press ENTER to run the macro, the row height will adjust initially to fit the text but the row width will remain the same. If you increase the text in the same cell, the row height will increase to fit the text but the cell width will remain the same. Now if you widen the cell by using the mouse, the cell width will increase but the row height will not decrease.

 

[AllisterB]

Hi Allister
When you press ENTER to run the macro, the row height will adjust initially to fit the text but the row width will remain the same. If you increase the text in the same cell, the row height will increase to fit the text but the cell width will remain the same. Now if you widen the cell by using the mouse, the cell width will increase but the row height will not decrease.

Thanks for your email.
In my post 11 i shoul have said
I was asking more like : if there is text and number formats on the same row will the macro change the height of the row if the changes to the text on that row requires a higher or a narrower row.

Thank you

Allister

 

[pincivma]

Thanks for your email.
In my post 11 i shoul have said
I was asking more like : if there is text and number formats on the same row will the macro change the height of the row if the changes to the text on that row requires a higher or a narrower row.

Thank you

Allister

The answer is NO. The macro only works on individual cells that you run the macro on and not on the entire row.