Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Refined...

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Thanks for the help with the previous query, but can anyone help me with this one? I need it to search through a sheet and every time it finds "Operator:" in a cell I need it to delete the 6 rows ABOVE it. There will be multiple occurences so I need it to loop until the sheet is clean

    If it helps, it will only appear in Column A but it could be any number of times

    Janie

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Change two lines of my last post from...

    Rows(ActiveCell.Row & ":" & ActiveCell.Row).Delete Shift:=xlUp
    LastRow = LastRow - 1

    To...

    Rows(ActiveCell.Row - 7 & ":" & ActiveCell.Row - 1).Delete Shift:=xlUp
    LastRow = LastRow - 6

    Should do the job.

    Rgds]
    AJ

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Thanks AJ

    xx

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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