Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA Question
Sub sheets_list()
Dim a As Long Dim s As Long Dim shtName As String s = 4 For a = 1 To Sheets.Count shtName = Sheets(a).Name Sheets(a).Hyperlinks.Add anchor:=Cells(a, s), Address:="", SubAddress:="'" _ & shtName & "'!A1", ScreenTip:=shtName, TextToDisplay:=shtName Next a End Sub My understanding is that the s = 4 determines the column where the list of worksheets should be returned, and this seems to be correct when I change the value. Also if I change a = 1 to a = 5 it starts the list in Cell D5 which is what I want. BUT......changing to a = 5 makes the macro only start returning the names from Sheet 5 in the workbook onwards. I want to return the entire list of worksheets in Cell D5. Can someone help please as I'm sure there is just something easy I need to change.....thanks! Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel 2002 Master Template Question | Excel Discussion (Misc queries) | |||
VBA Form ComboBox question | Excel Worksheet Functions | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |