WRAP TEXT TILL FULL VISIVILITY

[xenios]

Hi, please need help in current.
I have in a lot of cases when the text in a sheet is not visible till the end, and I have to drag the cell manually for the text to be visible, as it comes like that from a software for multiple sheets . May be there's is a VBA code for that? The example it attached.
In some cases it can be 1 like, in some 3 an in some even have to merge with the next cell to fit it.

 

[MARK858]

How are you defining which rows to autofit and how do you want the macro triggered?

By the way you don't need to drag the cell manually, you can select the rows (as long as they are contiguous) and double click one of the lines between the row numbers in the selected rows and it will autofit the row height (in your image if that is row 6 showing then select row 6 and double click that line you can see below the 6 in the image).

 

[xenios]

It shows me the whole text, but doesn't change the row height.
And I have to fix it for other people to read. + out of 300 sheets, 250 have this problem.

May be there is the way to do it without using vba, but I didn't find one.

 

[MARK858]

It shows me the whole text, but doesn't change the row height

I'm not sure how it can be showing you the whole text without it changing the row height but the syntax for autofitting rows is just

Rows("1:6").AutoFit

 

[xenios]

I'm not sure how it can be showing you the whole text without it changing the row height but the syntax for autofitting rows is just

Rows("1:6").AutoFit

Unfortunately not working, made it till cell 1000, till specific cell, still not.
It's also not working if I just row autofit manually on the sheet, makes it even smaller. I has by default wrap text and merge. But still (picture attached. May be just impossible.

 

[MARK858]

The merge cells are probably your issue, there is code around that might work but I am afraid that I don't write it as I hate merged cells.

 

[MARK858]

Have a play with the code by Smallman that I posted in the thread below.
Edit: probably better for you to play with the code in the last post first.

Auto Fit Row Height Of Merged Cells

Hi. Is there any way i can make excel autofit row height of merge cells?

www.mrexcel.com