Hello. I am stuck with an Autofit problem in an Excel table: autofit makes some rows higher even if there are no rows that would have any text that is wrapped in the table. I am trying to make it so the user can click on a button to make everything format properly.
The code below gives the same irregular result in the table as when I highlight rows of the table and double-click between the rows to auto-fit manually: row hight is still too tall for some blank rows in the table. I haven't had the same problem on other worksheets. Is there some other code to clear it out so it can autofit correctly or sme other solution??
-Alisser
The code below gives the same irregular result in the table as when I highlight rows of the table and double-click between the rows to auto-fit manually: row hight is still too tall for some blank rows in the table. I haven't had the same problem on other worksheets. Is there some other code to clear it out so it can autofit correctly or sme other solution??
Sub fit()
Range(ActiveSheet.ListObjects(1).Name & "[Column1]").Select
Selection.EntireRow.AutoFit
End Sub
Thanks!!Range(ActiveSheet.ListObjects(1).Name & "[Column1]").Select
Selection.EntireRow.AutoFit
End Sub
-Alisser
