| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel grouped data | Excel Discussion (Misc queries) | |||
| Grouped Items won't Stay Grouped When Moving Object | Excel Discussion (Misc queries) | |||
| Print Landscape/Portrait based on level of grouped data selected | Excel Discussion (Misc queries) | |||
| Check Boxes Grouped | Excel Discussion (Misc queries) | |||
| Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming | |||
Linear Mode
