Can I format cell to autonumber everytime I enter spreadsheet?

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

Grant

Can I format a cell to autonumber everytime I enter the spreadsheet?
 
What you want is
Private Sub Workbook_Open() ' in ThisWorkbook module
Sheets("Sheet1").Cells(1, 1) = Sheets("Sheet1").Cells(1, 1) + 1
End Sub
 
You must log in or register to reply here.

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

Events copy and paste 5
Excel Linking (I think) 17
Using functions in string formatted cells 4
Creating an AutoNumber ID as a primary key 2
How do I create an autonumber similar to Access in Excel? 2
Cell shows the last typed text, no matter where it is typed 0
Capture data from cell before Enter 1
Date formats 3

Back
Top