MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell that counts when opening a workbook


Posted by John S. on January 30, 2002 5:17 PM

I need a formula or macro that counts everytime a workbook is opened.


Posted by Carl B on January 30, 2002 6:10 PM

Private Sub Workbook_Open()
Range("A1") = Range("A1") + 1
End Sub

Posted by Carl B on January 31, 2002 7:07 AM

OOps Try this one

Private Sub WorkBook_Open()
Worksheets("Sheet1").Range("A1")=Worksheets("Sheet1").Range("A1") + 1
End Sub

Posted by John S. on February 01, 2002 5:54 AM

Re: OOps Try this one

Thats better thanks