Good afternoon Tigsboy

You will need a macro to do this for you, but just to put you on the
right track:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
With Range("A1")
.Value = .Value + 1
End With
End Sub

This routine when placed in the ThisWorkbook portion of the VBE will
increment the value in cell A1 by 1 everytime the workbook is closed

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=388929