Using VB, how to check if Excel Row is grouped as well as the level?

G

gladywin

Hi all,
I have a worksheet that has groupings. For example:

LIVING THINGS
-> ::Animals::
----> _Dogs_
--------> Bull Dog
--------> ...
----> _Cats_
-> ::plants::
----> _Palm_
----> _RainTree_

I am able to use VB to get the data out, but I am unable to know which
is sub-groups of which.

Is there any function that tells me whether a given row is grouped? If
grouped, what is the level? E.g. 1.1.2, 2.3.4.3, etc.?

My aim is to export the information out so that I can create a DHTML
menu (javascript) for it.

If you have other better suggestions, that would be great too!

Any comments or suggestions are greatly appreciate.

Thanks in advance.


Regards.
 
Top