Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTED SHEETS' NAMES
What looping code would display dialog boxes, one after the other, displaying
the names of the Sheets which are selected/grouped? -- Best Regards, Faraz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTED SHEETS' NAMES
I have found a code like:
Sub test() Dim sh As Worksheet For Each sh In ActiveWindow.SelectedSheets MsgBox sh.Name Next sh End Sub However, how to have the same names be placed at the very first available cells in the first sheet? -- Best Regards, Faraz "Faraz A. Qureshi" wrote: What looping code would display dialog boxes, one after the other, displaying the names of the Sheets which are selected/grouped? -- Best Regards, Faraz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTED SHEETS' NAMES
Dim sh As Worksheet
Dim NextRow As Long NextRow = 1 Worksheets(1).Columns(1).ClearContents For Each sh In ActiveWindow.SelectedSheets Worksheets(1).Cells(NextRow, "A").Value = sh.Name NextRow = NextRow + 1 Next sh -- __________________________________ HTH Bob "Faraz A. Qureshi" wrote in message ... I have found a code like: Sub test() Dim sh As Worksheet For Each sh In ActiveWindow.SelectedSheets MsgBox sh.Name Next sh End Sub However, how to have the same names be placed at the very first available cells in the first sheet? -- Best Regards, Faraz "Faraz A. Qureshi" wrote: What looping code would display dialog boxes, one after the other, displaying the names of the Sheets which are selected/grouped? -- Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide all sheets but selected sheets - an example | Excel Programming | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
Passing Selected Sheets' Names to a Macro | Excel Programming | |||
Worksheet Selected Names | Excel Programming |