![]() I get "runtime error 424: object required' Sheets("Sheet1").Cells(iCtr, 1).EntireRow.Delete If x.Value = Sheets("Sheet1").Cells(iCtr, 1).Value Then ' Loop through all records in the second list. IListCount = Sheets("Sheet1").Cells(Rows.Count, "C").End(xlUp).Rowįor Each x In Sheets("Sheet1").Range("Y1001:Y" & Sheets("Sheet1").Cells(Rows.Count, "C").End(xlUp).Row) ' Get count of records to search through (list that will be deleted)' 'Turn off screen updating to speed up macro' ![]() My code, however, is not producing this result! ![]() I am trying to compare a list from Column C with a list commencing at cell Y1001, and then where a duplicate exists, I want to delete the entire row of the duplicate from column C. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |