Why have you included
That seems unnecessary hereWorkbooks(Dir(Myfile)).RefreshAll
You should also stop all events and calculations before you start the loop and reset them after you the loop is completed
Why have you included
That seems unnecessary hereWorkbooks(Dir(Myfile)).RefreshAll
You should also stop all events and calculations before you start the loop and reset them after you the loop is completed
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks