Can I format cell to autonumber everytime I enter spreadsheet?

's Computer Specifications

Can I format a cell to autonumber everytime I enter the spreadsheet?

's Computer Specifications

What you want is
Private Sub Workbook_Open() ' in ThisWorkbook module
Sheets("Sheet1").Cells(1, 1) = Sheets("Sheet1").Cells(1, 1) + 1
End Sub

Grant <(E-Mail Removed)> wrote:
>Can I format a cell to autonumber everytime I enter the spreadsheet?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i get a cell in a spreadsheet to enter in a different cell	emma	Microsoft Excel Worksheet Functions	1	15th Apr 2008 02:58 PM
How do you enter a tick symbol into a spreadsheet cell please?	=?Utf-8?B?QXJtaXRhZ2UgU2hhbmtz?=	Microsoft Excel Worksheet Functions	4	24th Sep 2007 07:15 PM
Cell format changes General into Text after focus + Enter	AA Arens	Microsoft Excel Discussion	0	21st Feb 2007 02:33 AM
RE: Can I enter a tick sign in a spreadsheet cell somehow?	=?Utf-8?B?UHJhc2Fka2FrYXJsYQ==?=	Microsoft Excel Misc	0	20th Jan 2007 03:41 PM
How do I format a cell so that only specific numbers can be enter.	=?Utf-8?B?Smlt?=	Microsoft Excel Misc	1	1st Feb 2005 04:51 PM