I have a macro from a spreadsheet (A) that opens up another spreadsheet (B), copies a ranges and pastes it into the A spreadsheet, then closes B.
The thing is, after that it asks if I want to save the changes to B, and then it says there is a large amount of memory on the clip board and if I want it erased (is fo, choose NO). Is there a statement I can add to my macro to automatically choose No to both pop-up messagebox questions?
THANKS!
The thing is, after that it asks if I want to save the changes to B, and then it says there is a large amount of memory on the clip board and if I want it erased (is fo, choose NO). Is there a statement I can add to my macro to automatically choose No to both pop-up messagebox questions?
THANKS!