Grouping tabs with macro

[MrSums]

Odd problem: I have a spreadsheet with around 20 tabs. Half the tabs are detail sheets and the other half are summaries of the detail.

In order to speed up the configuration of these, I created macros to select either the summaries or the detailed sheets, here is the one for the summaries:

Sub Select_sheets()
'
' Macro to select all summary sheets'
'
' Keyboard Shortcut: Ctrl+s

Sheets(Array("UK Summary", "Auto HO", "Auto Lon1", "Auto Lon2", "Auto Lon3", _
"Auto Lon4", "Auto Lon5", "Auto Lon6", "Auto Lon7", "Auto Lon10", "Auto Man1")). _
Select
Sheets("UK Summary").Activate

End Sub

Now the odd thing is that, although the tabs are highlighted as if they were grouped, when I try to copy something from one sheet to all the others, it doesn't work. If I select the sheet manually, everything fine, but not with the macro doing the selecting.

Any help gratefully received

Robert

[MrSums]

'Bump' - nobody any clues?

[romperstomper]

As soon as you attempt to run the code, the copy gets cancelled. (You should see the same if you copy, then press Alt+f8 and just cancel). I'd suggest you include the copy in the code.

[MrSums]

As soon as you attempt to run the code, the copy gets cancelled. (You should see the same if you copy, then press Alt+f8 and just cancel). I'd suggest you include the copy in the code.

D'OH ..

Cheers

Robert