All,
I have the code below designed to remove any picture objects, reset the font, and delete some blank cells and some columns. I have it looping in a folder with about 52k workbooks that need to be modified. Unlike my other macros,this one has been running for 3 days and still isn't done. Is there something in the code that could be causing delays? The sheets are less than 100k in size each.
Thanks!
Please Login or Register to view this content.
Hi Sweepin,
I altered your code a little with a couple of comments - see if it's any quicker:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Yup, that's running much faster. Thanks!
Fantastic! Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks