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

G

Grant

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

JLGWhiz

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New documents automatically have text in superscript 0
Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
Auto match destination formatting for Mac 0
How can the font and size of (all) citation numbers be altered? 1
Excel - Wich Function should I use? 1
Paragraph numbering in Word 1
How to implement two shifts per day with multiple teams 0

Top