| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE ROWS FROM XLS IF THE ROW CONTAINS THE STRING
Hi
I wanted a macro , Which would find a particular string in that row and then delete that row. for example in the following example i want to delete all the Rows which contain the String "aaa","syz"......( I have about 500 words). aaa 1 jan bbb 2 feb aaa 3 mar bbb 4 apr aaaaa 5 may syz 6 jun xan 7 jul kjhf 8 aug aaa 4 feb I'll be happy if i get this in a VB application , Like the Application should browse for the XLS , then delete those Rows and give the final output as the XLS with deleted Rows( which had those strings) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| easy way to delete all rows with no text in them? | New Users to Excel | |||
| Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
| Want to delete rows | Excel Discussion (Misc queries) | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
| Any way to delete rows that don't contain 'x'? | Excel Discussion (Misc queries) | |||
Threaded Mode
