Applied Harald's suggested loop and it runs very fast on six formatting cell
on 21 sheets.

Regards
Bob C.

"Tom Ogilvy" wrote:

Grouping is not really supported in VBA. You can do some things by
selecting a range of cells and using the selection object (setting the
selection.interior.colorindex works for example), but the best is to loop as
Harald has indicated.

--
Regards,
Tom Ogilvy


"Robert Christie" wrote in message
...
Hi everyone

I recorded a macro to "Select All Sheets" in a workbook, then make a few
column formatting changes and then "Ungroup Sheets".
But when run as a Sub Procedure only the ActiveSheet is changed.
It appears that selecting all sheets and making any changes manually will
work but not when run as a sub Procedure.
Is this a default condition of Excel, if so is there a work around?

TIA

--
Thank you

Regards

Bob C
Using Windows XP Home + Office 2003 Pro