Trying to speed up the calculation my For Loop

[Astroboy142]

I hope the title to my thread is sufficient.

My code below checks to see if any change occurrs between Cells L5:GR12. Am I able to speed up the calculation time in anyway? I was trying to exit my for loop but that wasn't working for me.

Please Login or Register  to view this content.

[DonkeyOte]

In reality the Change Event is pref. to the Calculate Event because if offers Target - ie we know which cell(s) have been modified.

From the Target we should in turn be able to deduce which cell(s) [if any] require updating via the Change Event itself.

To determine the above we need to know the formulae contained within L5:GR12 [if any]

Also, do you have a Change Event in place on "Audit-Jan-Jun" sheet ?

[Astroboy142]

Hi DonkeyOTE,

Thanks for the reply. In range L5:GR12, no formula is present. A user would enter either a D, N, S, S10, etc in those cells. Depending on the entry the change event would color that cell.

Further, there is no change event occurring in the "Audit~Jan-Jun" sheet. A command button enters the values in that sheet only when called upon.

I changed my code and it works better with the exception for one thing. If I select a group of cells within L5:GR15 and hit deleted then I get a run time error 13. Any idea how to get around this one?

Please Login or Register  to view this content.

[DonkeyOte]

Without looking too deeply - perhaps try revising along the lines of:

Please Login or Register  to view this content.

Please Login or Register  to view this content.