Thread: How can I format a cell to automatically assign a new number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default 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?
Reply With QuoteReply With Quote