VBA is too slow, need a quicker solution

[Sthyne]

This VBA runs exactly as i need it to but it slows down my workbook too much. Is there a better way to accomplish this?

Please Login or Register  to view this content.

It continues on as well

[Glenn Kennedy]

Administrative Note:

Welcome to the forum.



Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Since you are an infrequent user, I have done it for you... this time. You can expect further incidences to result in your thread being BLOCKED until you do it yourself.

[SyracuseWolvrine]

To start with, I'd try combining some of the statements - you're doing a lot of checks to see if A5 equals "". You also don't need to specify ElseIf for the opposite.

Please Login or Register  to view this content.

How many rows are in your document?

[BMV]

The main problem is the macro started every change on the worksheet i mean. Please attache an exemple.

[SyracuseWolvrine]

The main problem the macro started every change on the worksheet.

That's also a good point. Ideally, you'd only trigger the macro if A5 (or one of the other cells mentioned) changed, not every single time any cell on the sheet changed.

[Sthyne]

Right now there are 200 rows in this worksheet but may increase to 250 or more

[Sthyne]

I combined the statements which helped a little. Ultimately I added...

At the beginning

Please Login or Register  to view this content.

At the end

Please Login or Register  to view this content.

It's no longer slow. Thanks for the help!