ExcelBanter - How can I format a cell to automatically assign a new number?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I format a cell to automatically assign a new number? (https://www.excelbanter.com/excel-programming/425275-how-can-i-format-cell-automatically-assign-new-number.html)

Grant

How can I format a cell to automatically assign a new number?

How can I format a cell to automatically assign a new sequential number each
time I open up the excel spreadsheet?

JLGWhiz

How can I format a cell to automatically assign a new number?

Private Sub Workbook_Open()
Sheets(1).Range("A1").Value = _
Sheets(1).Range("A1").Value + 1
ThisWorkbook.Save
End Sub

"Grant" wrote:

How can I format a cell to automatically assign a new sequential number each
time I open up the excel spreadsheet?

All times are GMT +1. The time now is 06:16 AM.