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/