Now that's an original approach!

To even think about using group and outline to hide rows and columns.<g

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
So it was "hide" and not "collapse".

Thanks for the feedback.

Gord

On Fri, 29 Sep 2006 05:16:02 -0700, Ray Naylor
wrote:

You guys are awesome!!!
Going to Format, Column, Hide worked. Apparently trying to use Data,
Group
and Outline, Group was not the way to go.

"Gord Dibben" wrote:

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord

On Thu, 28 Sep 2006 19:06:13 -0700, "RagDyer"
wrote:

You're confusing everyone by your use of incorrect terminology.

You're *not* looking to *hide* Column C.
You're looking to *collapse* Column C.
And you're looking to do this by using the *outline* symbols.

You *cannot* create and/or set-up groups of rows and columns while
*sheets
are grouped*.

You can create a single sheet with your groupings, and then copy that
sheet
to create other sheets with the same settings.

If the 30 sheets are already in existence, then perhaps code can do
this for
you.

Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP