Counter in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need a Cell, which will start at 1000 change every time I re-open the file to 1001, 1002 and so on

Could someone help me write what I beleive is a MACRO? [Office 2003]
 
This newsgroup is for ACCESS database product, not EXCEL spreadsheet
product.

However, you could run a macro on the Workbook's OnOpen event in EXCEL:

Private Sub Workbook_Open()
ThisWorkbook.Worksheets(1).Cells(1,1).Value =
ThisWorkbook.Worksheets(1).Cells(1,1).Value +1
End Sub

Above code will increment whatever value is in cell A1 of the first
worksheet in the file by the value of 1.
 
Back
Top