ExcelBanter - Can I format cell to autonumber everytime I enter spreadsheet?

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

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

- - Can I format cell to autonumber everytime I enter spreadsheet? (https://www.excelbanter.com/excel-programming/402428-can-i-format-cell-autonumber-everytime-i-enter-spreadsheet.html)

Grant

Can I format cell to autonumber everytime I enter spreadsheet?

Can I format a cell to autonumber everytime I enter the spreadsheet?

Dave D-C[_3_]

Can I format cell to autonumber everytime I enter spreadsheet?

What you want is
Private Sub Workbook_Open() ' in ThisWorkbook module
Sheets("Sheet1").Cells(1, 1) = Sheets("Sheet1").Cells(1, 1) + 1
End Sub

Grant wrote:
Can I format a cell to autonumber everytime I enter the spreadsheet?

All times are GMT +1. The time now is 06:45 PM.