Results 1 to 11 of 11

Thread: Delete all rows under a group

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    snb
    Guest
    Wouldn't this suffice ?

    Sub snb()
    Columns(2).Find("Closed Accounts", , xlValues, xlWhole).CurrentRegion.EntireRow.Delete
    End Sub
    or

    Sub snb()
    Columns(2).Find("Closed Accounts", , xlValues, xlWhole).resize(cells(rows.count,2).end(xlup).row).EntireRow.Delete
    End Sub
    Last edited by Aussiebear; 02-24-2025 at 03:41 AM.

Posting Permissions

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