Macro efficiency - Execute process faster

Hello all... again!!

I have a macro, that works totally fine, it is just SLOW AS HECK!!

here is the situation, and maybe what I already have is the best it can do... I just don't want to believe it though.. lol

ok.. I have a spreadsheet that has OVER 150000 rows, some of these rows have a duplicated value in a column (Column 'C').

I have this macro that steps backward from the bottom removing the duplicated rows based on that value, but before it does, it copies
the value from Column 'I' and pastes it into column 'G', then it will delete the original duplicate row.

it all works, but since I am not the VBA god as MANY on here, I was wondering for future knowledge if this could be written to be more efficient.

Thanks, and the code is below...

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

kalak,

That was a ton faster.. I didn't even have to get up and walk away from the desk when it was executed.

now, since this is a huge learning opportunity for me, could you further explain or breakdown the code so I can understand how it is working?

if you have the time...

I will no doubt have many more uses for it as I regularly have worksheets with close to the maximum rows of data to consolidate and would like to understand further.

Originally Posted by pjwhitfield

A really little one that might save a little time is to not copy/paste the I value but simply place it in the cell ie

Please Login or Register  to view this content.

I base this on nothing other than the belief that Copy/Paste must be more intensive than = plus it loses 2 lines of code.

Alternatively, you could CUT the value from I and therefore remove the need for the .ClearContents line

pjwhitfield,

I did incorporate your option as well on my test sheet.

It did reduce the execute time by a little and I do see your point on the reasoning for the suggestion.

Thank you..

This VBA stuff... always seems like there is something new to learn... I love it!

Originally Posted by Zoediak

... could you further explain or breakdown the code so I can understand how it is working?

here's an annotated version of that code

Please Login or Register  to view this content.

Kalak,

Thank you for the annotations... This will help me out a lot!!