Macro tuning

[lauren_wing]

hi

I am pasting code below.Can anybody please help me to reduce the performance.Right now it is taking 20 secs for 90000 rows of data.Can it be reduced furthur in case of perfomance by modifying the code using any other functions.


Her we have used Countif function,so can be furthur tuned and make the macro to run at a faster rate.


Please help me at the earliest.

Please Login or Register  to view this content.

Thnak you.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[shg]

Maybe you could explain what the code is doing so we don't have to reverse-engineer it, lauren.

I will say that the code commits the cardinal sin of modifying a for/next loop control variable (rownumber) within the loop.