[computerman29642]

Zack, the problem is that I am not sure how to handle the second find.

In the code I store the active sheet's (not the sheet where the data will be deleted) to a variable. I use that variable as the search criteria in the first find.

Do I need to store the next worksheet's name to a variable as well, and use that in the second find criteria?

[computerman29642]

I believe I have come up with a working code that should work.

Dim r1 As Range, r2 As Range, ws As Worksheet, x As Variant
    
    Set ws = Sheets("Main") 'Sheet that houses the data to be deleted when button on another sheet is pressed
    
    x = ActiveSheet.Name 'Variable that stores the name of the active sheet (sheet with deletion button)
    
    Set r1 = ws.Columns(1).Find(what:=x, after:=ws.Cells(1, 1)) 'Finds what is stored in the variable x

    Set r2 = ws.Columns(1).Find(what:="The header for the row", after:=r1).Offset(1, 0) 'Finds the row header of what should be the last row in teh group of data

    If r2.Row <= r1.Row Then
        'bad range
    Else
        ws.Activate 'Activates the main sheet
    'good range, use range here...
        ws.Range(r1, r2).Select '.EntireRow.Delete
    End If

The code works by running from a button on another sheet. The first find searches the main worksheet for the name of the active sheet (sheet that contains the button). The second find searches the for the row header for the group set (this should always be the last row in teh group/set of data) on the main sheet with the offset moving down one row (which will be the blank row between data groups/sets). Then the deletion happens.

Does anyone see any problems with the code?

[Zack Barresse]

No, I didn't use the activesheet, I referenced it explicitly. And I didn't select anything, so it shouldn't select the row, but delete it. I don't understand where that's coming from. Can you post a sample workbook? I don't know if I'll have time today, leaving in a bit, maybe later tonight, but I will be out through the weekend (school stuff).

[computerman29642]

No, I didn't use the activesheet, I referenced it explicitly. And I didn't select anything, so it shouldn't select the row, but delete it. I don't understand where that's coming from.

I changed it so that it would do a select instead of a delete. I did that for testing purposes.