Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text and remove row
I have a 10 column list. that list can have anwhere from
40-60 rows depending on the days information. I want to search column c for any cell containing the text "money market". once it finds a case where the cell contains the words "money market", then it highlights that entire row and delets it. then goes on to the next case and does the same. example cells: NEW YORK MONEY MARKET LOS ANGELES MONEY MARKET FEBRUARY FUND BELGIUM MONEY MARKET FUND DECEMBER etc. really appreciate any help available. thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text and remove row
Dim rng as Range
Dim i as Long set rng = Cells(rows.count,3).End(xlup) for i = rng.row to 1 step -1 if instr(1,cells(i,3),"money market",vbTextCompare) then cells(i,3).EntireRow.Delete end if Next -- Regards, Tom Ogilvy Stephen wrote in message ... I have a 10 column list. that list can have anwhere from 40-60 rows depending on the days information. I want to search column c for any cell containing the text "money market". once it finds a case where the cell contains the words "money market", then it highlights that entire row and delets it. then goes on to the next case and does the same. example cells: NEW YORK MONEY MARKET LOS ANGELES MONEY MARKET FEBRUARY FUND BELGIUM MONEY MARKET FUND DECEMBER etc. really appreciate any help available. thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and remove row | Excel Worksheet Functions | |||
Find and remove data from a column | Excel Discussion (Misc queries) | |||
Filter text in a column by its Indent, to remove certain text | 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 |