My column auto fit works in all sheets except Summary. Please open and you will see Runtime Error 1004.

Can someone tweek this for me? Thanks.

Attachment 175885