I have an Excel file with buttons and some other objects at the top (using Excel 2010). Below that is a bunch of data (approx. 800 rows, 40 columns). Also, many of the cells contain comments. I've had to write a macro that detects when a sort is performed to then do an autofit, because anytime I do a sort, the row heights do not autofit automatically with the sort. The problem is that autofitting via VBA just takes too long, especially compared to the built-in autofitting after sort. I've been trying to figure out why this is happening, and I believe I've found out, but I'm not sure how to fix it. When I remove all objects and comments from the sheet, a sort will then autofit automatically. Is there a way that I can keep objects and comments on the sheet but also maintain the built-in autofit after sort?