Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Search
Hi. I need to create a macro that will search a text string in a
particular sheet and delete the entire row if the string appears |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Search
Hi,
A bit short on detail but this looks for "Mytext" in column A and if it finds it deletes the entire row. Sub stantial() lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row For x = lastrow To 1 Step -1 Cells(x, 1).Select If ActiveCell.Value = "Mytext" Then Selection.EntireRow.Delete End If Next End Sub Mike "tc" wrote: Hi. I need to create a macro that will search a text string in a particular sheet and delete the entire row if the string appears |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Macro | Excel Discussion (Misc queries) | |||
A Macro to search and sum | Excel Programming | |||
Trying to search web via macro - possible?? | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |