Thread: how to increment a value by 1 everytime excel is closed?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rookie 1st class Rookie 1st class is offline
external usenet poster
  
Posts: 152
Default how to increment a value by 1 everytime excel is closed?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'On Close
Range("YourValue") = Range("YourValue") + 1
End Sub
Lou

"ruzual" wrote:

i want to increment a value by 1 everytime an excel sheet is closed. how to
do that?

Reply With QuoteReply With Quote