Application.screenupdating = False is not working

Hello,

I have a small macro which basically copies data from one sheet and pastes the data on another sheet. I don't want to see all of the actions happening so I am using turning off screen updating but it doesn't work. I can still see everything happening. Any ideas? Here is my code set.

Many thanks,
J

Please Login or Register  to view this content.

Hello Shg,

That worked very well for that part of the code. Would you be able to provide a solution for the other portion of code? As this uses the Select a lot and its the only way I know how to do this.

Many thanks,
J

Please Login or Register  to view this content.

Hello Shg,

It appears the solution your provided doesn't work as it does not delete any of the ranges.

Thanks,
J