Autofit Rows within Table

Hello,

I have a spreadsheet, unfortunately I cannot share the file (I know this may make this a little more complicated), where I have used a table from 'Table Styles' and record information.

I have a VBA so that certain tasks are carried out when I save the file; removing filters, hidding columns, setting widths.

I am trying to 'autofit' the rows and most work but every now and then a row doesn't autofit and two lines are squeezed into row height for single line. All cells are set to 'wrap text' through cell formatting, not through VBA coding.

This is the code that I am using for the sheet;

Please Login or Register  to view this content.

Can anyone help. I have tried searching for a way of looking at the number of lines in the row and setting the row height based on that.

Thank you.

I do know that if a row has merged cells for more than one column where "alt-Return" is used to create two lines, i.e., A2 and B2 are merged and the text has been split into two paragraphs with "alt-Return", then it will not auto-fit. Also, if a cell has a custom format longer than the cell it will not auto-fit that row