VBA that removes duplicate rows

I am a novice when it comes to VBA but I have written a subroutine that outputs exactly the data I want in many rows. The only problem is that some of the rows are repeats and so I would like to add a little more VBA code to remove the duplicate rows without the need of a filter.

Thus
if the output was originally
2.....4.....6.....8.....10.....3.....9
2.....4.....6.....8.....10.....3.....9
8.....3.....6.....8.....10.....3.....9
8.....3.....6.....8.....10.....3.....9
5.....3.....6.....7.....10.....3.....9
5.....3.....6.....7.....10.....3.....8
2.....4.....6.....8.....10.....3.....9

All that should be output is
2.....4.....6.....8.....10.....3.....9
8.....3.....6.....8.....10.....3.....9
5.....3.....6.....7.....10.....3.....9
5.....3.....6.....7.....10.....3.....8


Please advise.

Hi Dave,

Thank you for the prompt reply and the link.

It is interesting but I don't think the methods do quite what I had in mind.

I am hoping to add VBA to my subroutine, so that only unique rows are output.

Each row is of the same width (has the same number of columns).

Hi Roy

That is just what I wanted.
Thank you.

ps
For some reason I get no duplicates except that the first and last row are identical - but that's good enough for me.