Delete Duplicate Rows:use VBA

I want to use VBA to delete a row if it contains exactly the same data as another. I have been using this:

Please Login or Register  to view this content.

but it will only delete rows based on data from 1 column. I know this is a simple one - I just can't find the answer. Cheers.

Does anyone know? Thanks.