runtime error 1004

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

Do want to just skip the autofit on the Summary worksheet? It's throwing an error because of the merged cell.

Need autofit on Summary, unmerge is fine. Thanks.

Hello there can you please supply the password for you workbook?

Thanks!

Thank you. Merge is a killer. Have a blessed day. I am going to post the same worksheet in another post. I would like an SEP Date Control inserted and attached to a cell. I can't get it to attach. I will start another thread and unlock the sheets. Thanks again.

---------- Post added at 03:21 PM ---------- Previous post was at 03:19 PM ----------

password is "clf". I unmerged all of the headings in the workbook and not getting runtime error anymore. Please see the post above. Going to unlock and start another thread. Thanks.

Glad the unmerge worked for you.