delete duplicated first row

[marley&me]

Hi All

I am new to EXCEL VBA. I am learning to write a macro where any duplicate cell found in column B, the whole row (the first duplication not the second) will be deleted. I found this and amended a bit. It works but i do not really understand the command.

Please Login or Register  to view this content.

"old" is set as rw.cells(1,1).value. But there is no definition of the "lastest". How can VBA knows that "lastest" is actually the row after "old"?
thank 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

I will add them this time!

[royUK]

It appears that the varibles are not declared as specific types so Excel has to interpret them as Variants. This is inefficient & poor practice.