Very Small Error In Uniques arrangement Code, Need correction

Originally Posted by mangesh.mehendale

If I am checking correct code in workbook then there is problem Cells(i+4, "D") it should be Cells(i+4, 4) coz number of Col D is 4

Hello friend,

thank you for explanation, good points. after using your code same error is came kindly test.D2 cell existing text is erased and pasted as "Type3 Books". please fix.

Thanks.