how to release cpu usage after run macro

Hi everyone,

I made a macro that copy some info from a table with 2000 rows to aprox 30 new sheets.
I was monitoring the CPU and RAM usage, the RAM is OK, but I saw that the CPU before execute the macro was in 1%, while the macro is running it increase to 20%, and after that, the % doesn't decrease. I think I've tried everything, like save the file, using DoEvents function between and after the code, clicked the stop button in the programmer window (despite the macro is over), but nothing works. The only way is close and open the file, to restore the CPU usage to 1%.

And it's really important because while the cpu is in 20%, the ribbon is lagged, the option lists in the ribbon has ghosting, and is imposible to do a click in any option

I appreciate any opinion to solve this.

pd. Sorry for my bad english

Do you have a copy and paste line in your code?

If so try adding the line

Please Login or Register  to view this content.

after every .Paste line.

This line empties the clipboard after every paste and stops the clipboard expanding with data.

May not be the issue but without seeing the code we can only have a guess.

Hope this helps

thanx,
Inicially I copy paste the data to complete the table, but after that I copy the info to the new sheets with for loops like

Please Login or Register  to view this content.

etc.
but I'll use that for clear the clipboard.

Please Login or Register  to view this content.

Yes this will not need the clipboard to be cleared because it has not been used.

Maybe it is related to graphics:

Try the below, see if it makes any difference.

Options, Advanced. Go to the Display section and check the option for "Disable hardware graphics acceleration"

Hope this helps

I think that too, but it happened.
I made a short video to show the problem, sorry for the blurr but is sensitive info.
https://youtu.be/KgIav1a6eV4

Originally Posted by CheeseSandwich

Maybe it is related to graphics:

Try the below, see if it makes any difference.

Options, Advanced. Go to the Display section and check the option for "Disable hardware graphics acceleration"

Hope this helps

I did it, but doesn't work, the diference is minimun.

But is weird, because, sometimes only appears a little lag (cpu % low), and anothers lag and goshting (cpu %high)

Hi guys,

I want to say you that finally I solve this crap.

I divide the sub in few subs and run one by one to find what lines causes the mistakes

So I find some trash lines, that doesn't nothing and uses ram and cpu.
Like count how many sheets are visible for no reason
and some redundat code that I ran previously,

in conclusion, my mistake...


So thanks to everyone who reply my post,

see ya