G Grant Mar 9, 2009 #1 How can I format a cell to automatically assign a new sequential number each time I open up the excel spreadsheet?
How can I format a cell to automatically assign a new sequential number each time I open up the excel spreadsheet?
J JLGWhiz Mar 9, 2009 #2 Private Sub Workbook_Open() Sheets(1).Range("A1").Value = _ Sheets(1).Range("A1").Value + 1 ThisWorkbook.Save End Sub
Private Sub Workbook_Open() Sheets(1).Range("A1").Value = _ Sheets(1).Range("A1").Value + 1 ThisWorkbook.Save End Sub