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
|