Hi, I need to delete 1-2 rows of repetitive text which occurs on my spreadsheet at non regular intervals. I know how to delete to empty rows using an excel macro. But I need a macro to delete specific rows of text. This would greatly speed up my work. Can anyone help me please. Thanks and Bye

What is the criteria for selecting the rows to delete? Every third row or duplicate entries or rows that begin with the text that begins with the letter Z or what? How do you decide which rows you want deleted? Bryan

I don't use excel but could you not do this: insert a column in column A, enter the number 1 in the first row of it (maybe excel calls this cell A1 ?), put a1+1 in the second row, copy that cell down to the bottom of the spreadsheet such that the last one reads a2000+1, then force all these cells to be fixed numbers? You now have a column of fixed numbers going from 1 through 2000 or whatever. This comes in handy later. Then you sort the whole spreadhseet on the column containing the cells with the text you want to delete. This sort puts all such rows together in a bunch. Then you just mark them all and delete, as in "delete rows 800 through 1100". Then you resort the spreadhseet on column A, the column with the numbers you created earlier. This reverts the spreadsheet row order back to where it started, having eliminated the rows you didn't want. Then delete column A.

You might try posting this in the office software forum.