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