my program is 51MB and it does copy and paste data for many times. then when i try to run my program this error will appear:
"excel cannot complete this task with available resources. choose less data or close other applications.."
can anyone tells me what is the cause and the resolution of this error.
thank you.
Hi zieylar, welcome to VBAX,
One (or maybe two) things can lie at the bottom of this;
Basically, you are exceeding the memory (RAM) resources of your PC.
1) Make sure you put Application.CutCopyMode = False after each paste (this clears the clip board for the next copy)
2) 51MB is a large file, if you're opening and closing other files as well, these are all held in memory until you actually QUIT the application - just closing them does NOT take them out of the memory store. (Try to keep the number of files that've been opened down to a minimum)
HTH,
John
thank you John.
:yes