This code has slowed my entire tool down. What is wrong with it?

[rbs123]

Please Login or Register  to view this content.

[mehmetcik]

You have a loop there.

There are a lot of actions in that loop that are duplicated.

For example you are setting 9 cells to 0 as 9 instructions

Why don't you set the whole selection to 0 before you start?

why are you switching to sheet "acceptance" within your loop? You are already there.

what is this code doing inside your loop?

Please Login or Register  to view this content.

Surely all you needed was

Please Login or Register  to view this content.