Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel Macro to find instances of a word
I'm in the process of learning VBA and am having some troubles writing
an excel macro to find all instances of a word (usually in conjunction with other words) and delete the row containing it essentially I'd like row 5 below to do the following: If Cell contains word *foo* OR *baz* then such that it would find individual instances of foo and baz but also foobar Although overall a rather large macro, the code surrounding 1 Cells.Sort Key1:=Range("C1") 2 3 totalrows = ActiveSheet.UsedRange.Rows.Count 4 For Row = totalrows To 2 Step -1 5 IF CELLS(ROW, 3).VALUE = **FOO** OR CELL(ROW, 3).VALUE= **BAZ** Then 6 Rows(Row).Delete 7 End If 8 Next Row Thanks! --Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Instances Excel07..Excel Paste Special Menu Uses Word PS | Excel Discussion (Misc queries) | |||
Excel Macro to find instances of a word | Excel Discussion (Misc queries) | |||
Find/Replace macro from excel to word | Excel Programming | |||
Find/Replace macro from excel into Word | Excel Programming | |||
Change the Formatting of All Instances of a word in a worksheet in Excel | Excel Programming |