Otto,

My spreadsheet contains outlined data. I use the "1" and "2" boxes in the
upper left hand corner to hide / display the columns I have grouped.
Alternately, I could click the "+" /"-" above the outlined columns to
unhide/hide these columns.

I grouped these columns with the Data...Group and Outline menu command


Thanks for taking the time to respond.


--
Stephen


"Otto Moehrbach" wrote:

What do you mean by "collapsing" and "expanding". Hiding and unhiding?
Otto
"Stephen" wrote in message
...
What is the vba code for expanding and collapsing a range of columns or
rows?
I want my program to expand a group of columns, print a named range, and
then collapse it once again.

Any suggetions would be greatly appreciated.

Thanks!
--
Stephen