Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi Simbad,
If you go ...DataFilterAutoFilter Then filter for the rows containing e.g. "blue" and delete these rows. Go toggle filter off by... DataFilterAutoFilter This should work I think, Thanks Mike "Simbad" wrote: 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 |
#3
|
|||
|
|||
You can use Autofilter or a macro. Macro examples: http://www.ozgrid.com/VBA/VBACode.htm -- shternm ------------------------------------------------------------------------ shternm's Profile: http://www.excelforum.com/member.php...nfo&userid=858 View this thread: http://www.excelforum.com/showthread...hreadid=472176 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Macro to delete first line of 200+ files | Excel Discussion (Misc queries) | |||
How do I delete the line between 2 cells and merge them into one . | Excel Discussion (Misc queries) | |||
How do I delete every other line in an Excel document with over 3. | Excel Discussion (Misc queries) | |||
How to delete repeted rows automaticaly? | Excel Discussion (Misc queries) |