Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row with a certain phrase?
Is there any way to have excel automatically delete any rows that have given phrase in them -- dzi ----------------------------------------------------------------------- dziw's Profile: http://www.excelforum.com/member.php...fo&userid=1042 View this thread: http://www.excelforum.com/showthread.php?threadid=56128 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row with a certain phrase?
This link might get you started http://www.ozgrid.com/VBA/row-delete-criteria.htm VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=56128 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row with a certain phrase?
Alright. I have NO experience with VB or Macros in excel, so I have no idea how to set this up..any help? -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=561286 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row with a certain phrase?
Alright. Well all those scripts seem to have syntax errors. I used ones from http://www.rondebruin.nl/delete.htm I have a question. Is there any way to make it so that the value doesn't have to be the whole cell? i.e. Cell=Note: blah blah balh Cell2=Note: blah2 blah2 blah2 Is there any way to make it search for "Note:" and remove it? Becasue from what I've tried the value has to be the ENTIRE cell, not just part -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=561286 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert a number to phrase | Excel Discussion (Misc queries) | |||
Delete a row with a certain phrase? | Excel Discussion (Misc queries) | |||
How to highlight a row containing specific phrase? | Excel Worksheet Functions | |||
Subtotaling with Counting - not sure how to phrase this one... | Excel Discussion (Misc queries) |