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.
Bookmarks