I've only just seen this thread.
Is everything now working as expected?
I ask because there's a few things in the code that should be avoided, especially when automating Excel from another application.
The main thing is the use of ActiveCell/Select/Selection etc.
For example this,
could be done like this.
Instead of MyBook.ActiveSheet you could use MySheet, which is declared earlier in your code, but you would need to set it to reference the relevant worksheet.
Anyway, your code might work just fine as it is but it might be worth updating it.
Bookmarks