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

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

How can I format a cell to automatically assign a new sequential number each
time I open up the excel spreadsheet?
 
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

Automatic Secuential number 2
Can I assign a formula to track when another cell is changed? 3
Macro for sequential numbering 8
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet 7
Red cell for negative numbers in Excel 1
Cells drop leading zeros from numbers 7
macro to add button to a spreadsheet cell 4
Numbering documents 1

Back
Top