troubleshooting Question

Find with an OR

Avatar of Seamus2626
Seamus2626Flag for Ireland asked on
Microsoft Excel
6 Comments1 Solution244 ViewsLast Modified:
Hi,

I have a find piece of code as follows;

With ActiveSheet.Columns("K:K")
    Set rFind = .Find(What:="Corporate Actions", After:=.Cells(.Rows.Count, 1), LookAt:=xlWhole, _
                      SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
    If Not rFind Is Nothing Then
        .Range(.Cells(1, 1), rFind.Offset(-1)).EntireRow.Delete
    End If
End With

I would like to change so that it can find "Corporate Actions" or "Corp Action"

Thanks
Seamus
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros