View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
 
Posts: 211
Default 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