Still no joy on this. Have now migrated VBA scripts to using arrays in place of copy and paste which ended up being pretty simple (and a better way to do things). For information - using arrays makes a 8min execution time run in 7mins now.

But still have the resource problem. Can run the script no more than once. Any more than that I can't save the result (100MB file) due to lack of resources. Splitting the result is likely going to be the answer.

Is a 100MB file too large? I deal with engineering intensive applications all day, maybe it is too much for Excel??

Should I ask this question elsewhere?
TIA, euc