Autofit very slow

[Marc]

hello,

I've created a macro to analyse data automatically. At
the end I want to format the table in such a way that the
entire cell content is visible.

Columns("A:N").EntireColumn.AutoFit

This worked fine until I've added an additional column.
Now, the autofit can take up to a minute before it is
done. When I deactivate this line and do it manually I
have the same problem.
Table :
7570 rows / 14 columns -> autofit done almost immediately
7570 rows / 15 columns -> autofit very slow

Has anyone an idea? Thanks in advance.

 

[PegL]

Can't think why this is happening, but you might try
adding another autofit for the last column as a separate
statement in your macro.