JLG Copy Row

[Rpettis31]

I need help to complete a project.
It sort of works it just takes the last know value row that was true and
copy/pastes it not every row that met the condition as true. It is also
slow, is there another way to speed it up. I have updating false and my calc
to manual.

 

[Gary Keramidas]

add this to the beginning of your code

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

and this to the end:

Application.ScreenUpdating =True
Application.Calculation = xlCalculationAutomatic

 

[Rpettis31]

Gary,

I already have that done as noted in my initial query.

thanks

 

[Gary Keramidas]

sorry, you should post in the same thread then.