VBA example code for clearing a worksheet

worksheet_clear.vb

Sub ClearSheet()
    Dim sheetToClear As Worksheet
    Set sheetToClear = ActiveSheet ' Replace this with the sheet reference
    ' Delete something specific...
    ' sheetToClear.Cells.ClearFormats
    ' sheetToClear.Cells.ClearContents
    ' sheetToClear.Cells.ClearHyperlinks
    
    ' ...or every kind of data in the cells
    sheetToClear.Cells.Clear
End Sub

Nice, thank you!