VBA to apply Grouping based on Leading Blanks in an Essbase Indented Retrieve

[David Beard]

The Hyperion Essbase Zoom-in displays members of a hierarchical dimension in a single column, with leading blanks in front of the member names. The number of leading blanks indicates the Level (generation) of the member. The top of the hierarchy has zero leading blanks, next level has five, next level has 10, and so on in increments of five. The number of levels might be indeterminate until the data is retrieved, but in fact will probably be known and not volatile.

I was looking for help and suggested VBA to apply outlining/grouping based on all levels present in the data.

Thanks.