Change default height for autfit

[Juujjj]

Hi, I'm new to the forum and kind of new to vba.

I'm working on a table formatting code, and I want to change the default autofit height. That's it. I want to be able to wrap text and have the table dynamically resize the height of the row based on that, but I want to be able to set the row height.

I feel like this should be able to be set in settings, but I can't figure it out. If I need to include it in my vba code, I will.

Thanks in advance for your help,

Juujjj

 

[Coding4Fun]

Right click the sheet that contains the table and view code - paste the following into the VBA window that opens.
Now when you update a table on this sheet it will autofit the row-height, you can then manually adjust the row-height if needed. Once you change the text it will autofit again.

Private Sub Worksheet_TableUpdate(ByVal Target As TableObject)
ActiveRow.AutoFit
End Sub

 

[Juujjj]

I think you misunderstand me. I am looking to change the height to which autofit aligns. Say, I want the row height to be 20 by default, instead of 12 for autofit. I want to be able to set the default row height, but have it double or triple according to how many rows of text there are.