Hi,

I trying to make a macro that does some copying and pasting between worksheets, but for some reason it is running really slowly. it also seems to get slower with time, if I try to run a 2nd and 3rd time to the point that the code doesn’t completely run at all, and I have to Ctrl+Alt+Delete, just to be able to close excel.

I think it may be because there is some code in the worksheet that is designed to run whenever there is a worksheet_change sub, however, I placed the entire worksheet_change code inside an if statement to try to skip it but the code still runs slowly. It fails when it gets to the worksheet_change

I cant attach the file, because it's more than 1MB, but would anyone know if there is a way to deactivate a "Private Sub_Worksheet Change" sub so that it does not run, and then activate it back up again?

thanks, I really appreciate the help.