I need faster code

Does anyone have any suggestions on how to speed this up? I need it to be as fast as possible.

Please Login or Register  to view this content.

Hello Mpeplow,

It would be faster to call the basic If portions of your Find macro from the Change Event for each check box involved.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Mpeplow,

It would be faster to call the basic If portions of your Find macro from the Change Event for each check box involved.

Sincerely,
Leith Ross

I'm sorry, I don't quite follow you. Could you show me or point me to an example please?

Thank You

Hello Mpeplow,

Do you need to do this as a "batch"? Say, the macro is being called from a command button?

Thanks,
Leith Ross

Hello Mpeplow,

Try this version, and let me know what happens. Since I don't have the data you have, this macro hasn't been tested. Use a copy of your workbook to test it.

Revised Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross