Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create worksheet index
Hi there, Is there anyway I can user a macro to create an index of all the worksheets in a workbook? Ideally it'll create a worksheet at the front of my book listing the names of the worksheets which follow in the same book? Can anyone help please? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create worksheet index
Take a look he
http://www.mvps.org/dmcritchie/excel/buildtoc.htm In article , index wrote: Hi there, Is there anyway I can user a macro to create an index of all the worksheets in a workbook? Ideally it'll create a worksheet at the front of my book listing the names of the worksheets which follow in the same book? Can anyone help please? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create worksheet index
Here's a quick and dirty that might get you started
'----- Option Explicit Sub makeIndex() Dim shNum As Integer Worksheets.Add befo=Sheets(1) For shNum = 2 To Sheets.Count Range("A" & shNum - 1).Value = Sheets(shNum).Name Next End Sub '----- HTH Anders Silven "index" skrev i meddelandet ... Hi there, Is there anyway I can user a macro to create an index of all the worksheets in a workbook? Ideally it'll create a worksheet at the front of my book listing the names of the worksheets which follow in the same book? Can anyone help please? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create worksheet index
Thanks for your hel ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create an index for my book? | Excel Discussion (Misc queries) | |||
Create Dependent Lists using an INDEX function?? | New Users to Excel | |||
How do I create an index or TOC for worksheets in an excel workboo | Excel Discussion (Misc queries) | |||
Can I create an index in an excel table? | Excel Discussion (Misc queries) | |||
hyperlinks to create an index | Excel Discussion (Misc queries) |