I have tried 2 options to autofit column width but receive the following error:
Run-time error '1004':
Application-defined or object-defined error
Thanks in advancePlease Login or Register to view this content.
I have tried 2 options to autofit column width but receive the following error:
Run-time error '1004':
Application-defined or object-defined error
Thanks in advancePlease Login or Register to view this content.
Your code seems to works fine...Simplify to:
Edit...Please Login or Register to view this content.
Is there any other code in the Sub.....
Last edited by sintek; 12-05-2017 at 02:50 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks for your response - My code was OK but "Summary" sheet was protected - I unprotected, ran code & re-protected.
Coolio....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks