Hi there,

Is there any quick way in VBA of taking each row in a spreadsheet and checking to see whether there is a duplicate row elsewhere on the sheet.

I should be clearer - I'm not actually looking at the whole row, only columns A to F and M to BS.

Can anyone suggest some code? Thanks