Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • 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
Joined
Mar 8, 2003
Messages
1
Location
IE
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
 
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

Back
Top