Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
code to remove rows containing a character string
I want to create a macro to remove all the rows of a table in which the cell
in column C contain "FM" within the text string. For some reason, when I set up a macro to do a filter of "contains FM" then try to delete just those rows, the macro deletes all rows. After that ... I need to do the opposite. Need to delete all rows that does NOT contain "FM". Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove special character at end of string | Excel Discussion (Misc queries) | |||
Remove last character of text string | Excel Worksheet Functions | |||
Remove all characters following the first character in a string | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |