View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel[_7_] joel[_7_] is offline
external usenet poster
 
Posts: 1
Default VBA: Collapse Column Groupings


I think you would want to keep the 1st columns H, BD, and BJ and hid the
other columns or unhide these columns

columns("I:AB").Hide
columns("BE:BF").Hide
columns("BK:CD").Hide

columns("I:AB").UnHide
columns("BE:BF").UnHide
columns("BK:CD").UnHide


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151848

Microsoft Office Help