Auto Row-Height in an Excel Table

[diver999]

I have a large spreadsheet which automatically constructs a summary cell at the end of each row. To do this I use CONCATENATE & include char(10) to generate separate lines within the summary.

The summary columns is formatted to wrap text.

The problem is that whatever I do, I cannot get each row to auto adjust the row height when I create a new row in the table.

Any ideas?

Tnx D

[Keebellah]

Hi, welcome to the forum
The following code after all the updates en before exiting the routine

Please Login or Register  to view this content.

[diver999]

Thanks for the quick reply. I should have said that unfortunately, I can't use any VB code due to a corporate restriction.

Any other ideas?

[Keebellah]

If you create a new row, do you also copy the format of the row above?
Word Wrap ON is the only thing I can think of