-
In Macro - Clear Clipboard / Free up Memory
Hello,
I have a macro that does a ton of large copy/pastes of huge formulas. In order to reduce the size of the "report" file, my macro then turns all the data into values.
I'm encountering an error message when my macro saves the file. It says I don't have enough system resources to complete the selected task (save the file).
I'm under the assumption this mean memory (since I have gobs of HD space). I tried increasing my virtual memory to max, but that doesn't help. I'm just wondering if my "copies" are still stored in memory somewhere, and that is why my machine is telling me I don't have enough resources. If so, is there any code I can apply that will remove the "copy" from memory once I paste it in?
Any thoughts would be helpful. Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules