AFAIK that doesn't exist but look in the ThisWorkbook module and specify
your sheet and range.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"E" wrote in message
...
Like the title says, I am working on a project in Excel that requires that
the data entered in a range be cleared. I tried the following code in the
deactivate event of the worksheet:

Private Sub Worksheet_Deactivate()
Range("b18:l40").ClearContents
End Sub

This works fine if I switching worksheets but I would like the clear to
occur when closing Excel. I did not see a "OnClose" type event where I
could
put the code for clearing the selection.

Thanks in advance.