Hello,
I have about 200 xls files that need updated text (mainly dates). I have pieced together some code that worked on different projects but am getting a run-time '91' error now.
It runs correctly once but on the second pass the run-time error pops up and the debug references the "For Each sht In wbSource.Sheets" line.
Please Login or Register to view this content.
Any help would be greatly appreciated!
Thank you for your time,
-Kyle
Last edited by kshimabukuro; 12-07-2010 at 02:16 PM.
Try this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you so much Jerry! Code works great and looks much cleaner than what I had too. Thanks again!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks