Clear Sheet1 on closing Workbook

[Dougie1]

Good Morning All,

After some help here if possible.

Using Excel 2016.

I have data on Sheet1 (sheet is actually named “Master Data Sheet”).

What I would like to do is clear this sheet on closing the Workbook – except for Row A – which I would like to remain as it contains Header data.

Can anyone help please?

Thanks in advance.

D1

 

[FormR]

except for Row A

Hi, assuming you mean row 1 (A refers to a column) you could try this in the ThisWorkbook module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Master Data Sheet").UsedRange.Offset(1).ClearContents
End Sub

 

[Dougie1]

thanx FormR (yeah I did mean row 1 not row A!)

I will try this code on my workbook when I get home.

Thanks again for your help