![]() However, keep in mind that if you've sorted the data in such a way that you're duplicate rows are no longer adjacent to each other, then this macro will not achieve what you actually need. ![]() ![]() I've answered this question on the basis of the original title and the requirement you've specified (i.e. After it’s finished every second row will be deleted.Now wait a while for the macro to finish (how long it takes depends on how many rows you have - but it should take no more than a few minutes at most).In the Macro window that appears, select the DeleteEverySecondRow macro and click on the Run button.In the code window that appears, enter the code below (you should be able to just copy & paste it) Sub DeleteEverySecondRow()įor i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -2Ĭlose the window and return back to your spreadsheet This will bring up a Project window with the name of your first sheet highlighted - Double-click on the sheet name.Go to Tools > Macro > Visual Basic Editor.All duplicate rows are adjacent to each other) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |