Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet name list
The following macro (list links of worksheets of workbook) was posted by Mike
H. It does not work if the sheet name contains a space. Is there any way I can change the macro to make it work. Thanks. Sub sonic() Sheets("Sheet1").Select For x = 1 To Worksheets.Count Cells(x, 1).Hyperlinks.Add Anchor:=Cells(x, 1), Address:="", _ SubAddress:=Worksheets(x).Name & "!A1", TextToDisplay:=Worksheets(x).Name Next lastrow = Sheets("sheet1").Cells(Cells.Rows.Count, "A").End(xlUp).Row Range("A1:A" & lastrow).Sort Key1:=Range("A1"), Order1:=xlAscending End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list sheet 1 - same cell (eg A1) in a group of worksheets sheet | Excel Worksheet Functions | |||
Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
TAKING INFO FROM ONE SHEET AND PRODUCING A LIST IN ANOTHER SHEET | Excel Discussion (Misc queries) | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |