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