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

Getting filename data 7
macro to add button to a spreadsheet cell 4
How do I set up a column to automatically number the next row 4
How can I get Outlook to automatically assign a number to tasks? 1
Red cell for negative numbers in Excel 1
Data exchange between macro and spreadsheet 1
Can I assign a formula to track when another cell is changed? 3
Truncate a cell value 2

Top