Wrap Text: Autofit rows that are merged across

Hi All,

I was wondering if anyone knew of a way to wrap text by using autofit on a merged range. In the data I'm working with, beginning at row 16 (the header is 14 rows followed by an empty row), columns F:I are merged. When I run this:

Please Login or Register  to view this content.

The code executes but nothing happens. Any text that should be displayed after a column is resized is still not visible. My question is, would it be possible to to apply autofit to this range, or to make the merged row only one cell the same width as the merged range.

The reason for working with merged cells is that I'm attempting to create a comparison report between two reports that are exported out of a database in excel format, and the intent is to compare these two reports side by side on the same screen while preserving the original format. By resizing two columns this can be acheived, but the all text in the string still needs to be visible.

Any help would be greatly appreciated, thanks!

Try

Please Login or Register  to view this content.

Hello Ab33, thanks for the reply!

When I run it that way, it resizes the rows, but the wrapped text is still not visible.

Thanks

hi Pierce Quality, can you post a sample file?

That executes, but does not appear to do anything.

Here is a sample book:

Thanks!

Just remind us, what are you trying to do?

Originally Posted by AB33

Just remind us, what are you trying to do?

Attempting to wrap text in a range that is merged across then auto fit the rows. Hopefully its possible!

Pierce,
I am not sure I understand your request.
For e.g, you have rows 16-24 wrapped and merged. It might be easier to record your actions and see what the record macro shows.

Originally Posted by AB33

Pierce,
I am not sure I understand your request.
For e.g, you have rows 16-24 wrapped and merged. It might be easier to record your actions and see what the record macro shows.

In the attached workbook, the text to be wrapped is not displayed. Although autofit does resize the rows somewhat, is does not resize enough to be effective. This may be because of the merged cells.

Thanks

Do you mean when you enlarge the text(To size 18) the text does not show(The full text is not shown)?

Please Login or Register  to view this content.

please check attachment

Originally Posted by AB33

Do you mean when you enlarge the text(To size 18) the text does not show(The full text is not shown)?

Originally Posted by AB33

Please Login or Register  to view this content.

AB33,
The font change was not an issue.

Autofit would not work on when the cells were merged.

Watersev,

This appears to do the trick, thank you very much!

Marking this as solved, thanks everyone!