Group & Outline - how do I hide detail programmatically

[Sam Wilson]

Dear all,

I've written some code that runs down a column and uses the data therein to
group some rows together. All so far so good, but I want the default display
to be with detail hidden.

Any pointers?

 

[Sam Wilson]

I'm going to answer my own question in case anyone else searches and finds
it...

I used ExecuteExcel4Macro "SHOW.DETAIL(a,b,c,d)"

In the string a,b,c,d the letters represent the following:

a=1 (indicates rows)
b=last row number to hide
c=FALSE (indicates hide, TRUE indicates show)
d= row above where group starts

Sam