JeffT
02-15-2011, 01:23 PM
Hi
I've a Macro which groups lots of data & another which ungroups, all of which work fine. However the other day I noticed the grouping was happening from the bottom not the top as usual.
Somehow the "Summary rows below detail" box in settings was ticked. What I would like to know is if there is some code which I could add to the Macro to ensure this setting was unticked before the code ran.
Thanks
JeffT
I've a Macro which groups lots of data & another which ungroups, all of which work fine. However the other day I noticed the grouping was happening from the bottom not the top as usual.
Somehow the "Summary rows below detail" box in settings was ticked. What I would like to know is if there is some code which I could add to the Macro to ensure this setting was unticked before the code ran.
Thanks
JeffT