MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Group Editing (VBA)

Posted by Carl Rardon on January 11, 2001 8:39 AM

I cannot find any object in VBA to identify the currently selected set of worksheets in group editing mode. Is there any way to programatically obtain the list of files in the group editing array?

Posted by Robert on January 11, 2001 5:33 PM

SelectedSheets property of the windows object:

for each sheet in ActiveWindow.SelectedSheets