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

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.


---
Message posted from http://www.ExcelForum.com/