ExcelBanter - Clear a sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clear a sheet (https://www.excelbanter.com/excel-programming/354952-clear-sheet.html)

Clear a sheet

Seek clean alternative to :

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

Thanks.

Harald Staff

Clear a sheet

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.

RB Smissaert

Clear a sheet

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.

All times are GMT +1. The time now is 08:28 PM.