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? :confused: -- Taylor ------------------------------------------------------------------------ Taylor's Profile: http://www.excelforum.com/member.php...o&userid=34166 View this thread: http://www.excelforum.com/showthread...hreadid=539289 |
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? :confused: -- Taylor ------------------------------------------------------------------------ Taylor's Profile: http://www.excelforum.com/member.php...o&userid=34166 View this thread: http://www.excelforum.com/showthread...hreadid=539289 |
All times are GMT +1. The time now is 06:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com