Clear a sheet

[[email protected]]

Seek clean alternative to :

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

Thanks.

[Harald Staff]

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

HTH. Best wishes Harald

<[email protected]> skrev i melding
news:[email protected]...
> Seek clean alternative to :
>
> Public Sub ClearSheet(sheet As Worksheet)
> sheet.Activate
> Cells.Select
> Selection.ClearContents
> Selection.Clear
> End Sub
>
> Thanks.
>

[RB Smissaert]

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


<[email protected]> wrote in message
news:[email protected]...
> Seek clean alternative to :
>
> Public Sub ClearSheet(sheet As Worksheet)
> sheet.Activate
> Cells.Select
> Selection.ClearContents
> Selection.Clear
> End Sub
>
> Thanks.
>