Deleting duplicate rows

**therealjag** · 12-08-2009, 05:08 PM

Hi there,

I have a sheet where i want to delete duplicate rows where column A and column B combined are equal, i.e. range(Ax:Bx) where x is the current row.

I am using the macro below but cant seem to get it working as I keep getting a type mismatch error and Im not sure why.

Please Login or Register  to view this content.

Does anyone know why I'm getting this error? If so that would be a great help. I've attached my workbook for your reference.

Thanks,

Jag

**tigertiger** · 12-08-2009, 05:39 PM

I just look it, so try to correcting like that:

Please Login or Register  to view this content.

**therealjag** · 12-09-2009, 04:53 AM

Ahh Tiger Tiger thanks for your help! Its always good to get a second opinion on this and just splitting the range up makes so much sense...just a fact of me being stuck in my ways to get the other way working.

Cheers blud!