Hi,

In my workbook I am generating new sheets with macros. In each new sheet certain rows (using custom auto filter) need to be deleted from the initial sheet. There are also formulas in the sheets. Deleting the rows takes forever. Is there any way I can speed it up?

Thanks for your help

Tried the codes, didn't work. I got it to work a little faster, don't know how, though. Just saved it under a different name and the macros were faster.

Hi,

Turn of ScreenUpdating and Automatic calculation


Application.ScreenUpdatind=False
Application.Calculation=xlCalculationManual

'Your Code

Application.ScreenUpdatind=True
Application.Calculation=xlCalculationAutomatic

-vemaju