Seek clean alternative to :

Public Sub ClearSheet(sheet As Worksheet)
sheet.Activate
Cells.Select
Selection.ClearContents
Selection.Clear
End Sub

Thanks.

Public Sub ClearSheet(sheet As Worksheet)
sheet.Cells.Clear
End Sub

HTH. Best wishes Harald

skrev i melding
oups.com...
Seek clean alternative to :

Public Sub ClearSheet(sheet As Worksheet)
sheet.Activate
Cells.Select
Selection.ClearContents
Selection.Clear
End Sub

Thanks.

Simply:

Public Sub ClearSheet(sheet As Worksheet)
sheet.Cells.Clear
End Sub

I would change the variable sheet though as I think it
is a reserved word.

RBS


wrote in message
oups.com...
Seek clean alternative to :

Public Sub ClearSheet(sheet As Worksheet)
sheet.Activate
Cells.Select
Selection.ClearContents
Selection.Clear
End Sub

Thanks.