Results 1 to 4 of 4

Delete next row after a search.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Delete next row after a search.

    Hello,

    Need help here!

    Cells.Find(What:="Q3-OND'12", After:=ActiveCell, LookIn:=xlFormulas, _
            LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False).Activate
        Selection.End(xlDown).Select
        ActiveCell.Offset(1, 0).Select
    cell.EntireRow.Delete
    I am trying to find a word in excel, then go to its next row and delete the entire row. I created the code, but somehow it is working. I think I am not fixing it correct at the last code. Please assist.

    Thanks
    Shiva
    Last edited by shiva_reshs; 01-29-2013 at 05:45 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1