Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to aquire list of worksheets
Sorry, replied before thinking... Sub MacroAddNewFileListSheetNames() ' Creates a list of names of the sheets in SHEET Master Numbers, Colum I (emitts Master Numbers) Range("I1").Select For Each Sheet In ActiveWorkbook.Worksheets Select Case Sheet.Name Case "Master Numbers" 'Ignore *CASE* Else ActiveCell.Value = Sheet.Name Cells(Cells.Row + 1, Cells.Column).Activate End Select Next End Su -- aking198 ----------------------------------------------------------------------- aking1987's Profile: http://www.excelforum.com/member.php...fo&userid=1539 View this thread: http://www.excelforum.com/showthread.php?threadid=31434 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of worksheets | New Users to Excel | |||
Get a list of worksheets from a WB | Excel Discussion (Misc queries) | |||
Sub to aquire list of worksheets | Excel Programming | |||
Sub to aquire list of worksheets | Excel Programming | |||
Get a List of Worksheets | Excel Programming |