Autofit columns error

**Aland2929** · 12-05-2017, 02:24 AM

I have tried 2 options to autofit column width but receive the following error:
Run-time error '1004':
Application-defined or object-defined error

Please Login or Register  to view this content.

Thanks in advance

**Sintek** · 12-05-2017, 02:32 AM

Your code seems to works fine...Simplify to:

Please Login or Register  to view this content.

Edit...
Is there any other code in the Sub.....

**Aland2929** · 12-05-2017, 03:01 AM

Thanks for your response - My code was OK but "Summary" sheet was protected - I unprotected, ran code & re-protected.

**Sintek** · 12-05-2017, 03:02 AM

Coolio....

Re: Autofit columns error