View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michiel via OfficeKB.com Michiel via OfficeKB.com is offline
external usenet poster
 
Posts: 48
Default How to hide and show a grouped column via VBA code?

Hi,

I can Group a column e.g. via:

columns(3).columns.group

When I do this the result is a line on top of col C and D with a little box I
can click on to hide column C. Leaving just a box with a little PLUS above
column D.

How can I appy that directly via VBA code?

Thanks!

--
Message posted via http://www.officekb.com