Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro to delete specific rows of text

Status
Not open for further replies.

alphakc

Chemical
Mar 8, 2003
1
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
 
Replies continue below

Recommended for you

Just do a search for any unique text contained in the row, select the row and delete. TTFN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor