D
dave
Is there a quick way to list all sheet tab names into a
given sheet column for quick reference purposes?
tia,
Dave
given sheet column for quick reference purposes?
tia,
Dave
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
D
dave
thanks - got it!
-----Original Message-----
Hi Dave
have a look at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
--
Regards
Frank Kabel
Frankfurt, Germany
.
G
Gord Dibben
Dave
Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add
For Each ws In wkbkToCount.Worksheets
.Rows(iRow).Cells(1).Value = ws.Name
iRow = iRow + 1
Next
End With
End Sub
Gord Dibben Excel MVP
Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add
For Each ws In wkbkToCount.Worksheets
.Rows(iRow).Cells(1).Value = ws.Name
iRow = iRow + 1
Next
End With
End Sub
Gord Dibben Excel MVP
N
Norman Harker
Hi Dave!
For even quicker reference, right click on any of the arrows to the
left of the worksheet tabs. It's also a fast way of navigating to the
sheets if there are a lot of them.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
For even quicker reference, right click on any of the arrows to the
left of the worksheet tabs. It's also a fast way of navigating to the
sheets if there are a lot of them.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.