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!