LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Simbad
 
Posts: n/a
Default Line delete automaticaly


Hi,

Is it possible to delete complete lines automaticaly?

I mean that for example, I want to delete all lines containing a
certain word or phrase (not a single cell or a find replace), say all
lines that contain the word ''blue'', can this be done or do I have to
scroll down the entire worksheet and manually delete the lines?

Thanks!


--
Simbad
------------------------------------------------------------------------
Simbad's Profile: http://www.excelforum.com/member.php...o&userid=27702
View this thread: http://www.excelforum.com/showthread...hreadid=472176

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro data selection line delete Frantic Excel-er Excel Discussion (Misc queries) 0 May 31st 05 11:46 PM
Macro to delete first line of 200+ files Bob Dobalina Excel Discussion (Misc queries) 2 May 26th 05 10:04 PM
How do I delete the line between 2 cells and merge them into one . Eric Excel Discussion (Misc queries) 2 April 11th 05 09:44 PM
How do I delete every other line in an Excel document with over 3. Darren Excel Discussion (Misc queries) 3 December 22nd 04 06:50 PM
How to delete repeted rows automaticaly? gabarrao Excel Discussion (Misc queries) 5 November 27th 04 01:48 AM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"