Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic numbering of spreadsheets
Is there a way in which to either use a formula or another method of being able to automatically number spreadsheets without having to do so manually? -- Taylor ------------------------------------------------------------------------ Taylor's Profile: http://www.excelforum.com/member.php...o&userid=34166 View this thread: http://www.excelforum.com/showthread...hreadid=539289 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic numbering of spreadsheets
You need a VBA procedu
Sub AAA() Dim WS As Worksheet For Each WS In ActiveWorkbook.Worksheets WS.Name = WS.Index Next WS End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Taylor" wrote in message ... Is there a way in which to either use a formula or another method of being able to automatically number spreadsheets without having to do so manually? -- Taylor ------------------------------------------------------------------------ Taylor's Profile: http://www.excelforum.com/member.php...o&userid=34166 View this thread: http://www.excelforum.com/showthread...hreadid=539289 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel automatic numbering | Excel Discussion (Misc queries) | |||
How do I set up automatic sequentially numbering for worksheets? | Excel Worksheet Functions | |||
automatic numbering | Excel Worksheet Functions | |||
Auto numbering of spreadsheets | Excel Discussion (Misc queries) | |||
automatic sequential numbering in excel or word | Excel Discussion (Misc queries) |