Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run a macro that will delete row if a certain keyword is
spotted, but I have to run the macro multiple times before it cleans out the spreadsheet completley. Below is what I have. Sub Delete() Dim myRange As Range Dim iLastRow As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row Set myRange = Range("G2:G" & LastRow) For Each c In myRange c.Select If c.Value = "FUNDED" Or c.Value = "DOCS-OUT" Or c.Value = "PURCHASED" Then ActiveCell.EntireRow.Select Selection.Delete End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to copy a value multiple times depending on value in adj | Excel Worksheet Functions | |||
Need To save a spreadsheet multiple times through a macro | Excel Programming | |||
Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
Run macro multiple times | Excel Programming | |||
Detect Macro Completion | Excel Programming |