Remove duplicates without removing formatting?

All,
I have the following line of code in my macro...

Please Login or Register  to view this content.

This finds duplicates in columns 1 and 9 and then removes everything in that row, including the formatting. Can this line of code be changed to remove values only but leave shading a boarders? Thanks for any suggestions.

Wow. There's stuff in there that I've never seen before. I'll give that a try. Is there a way to remove the entire row with the duplicate rather than deleting the cell values and formats?

Thanks for the reply. I was meaning using my original line of code, can I re-write it to delete the whole row rather that just deleting the cell values and formats? My original line of code works perfect for what I want to do, except I lose the formatting. If I can make the whole duplicate row go away, then I can also achieve my goal.

Thanks

Yeah. I understand that now, I can't remove duplicates but still preserve the formatting. But, can I remove duplicates and delete the entire row?