Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
using 2003. I need to capture the outline level and or if columns/
rows have been grouped. I know how to set the outline level but how can I capture if/what the outline level is? meg99 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For any given row?
Dim myRow As Range Set myRow = ActiveSheet.Range("a17").EntireRow MsgBox myRow.OutlineLevel meg99 wrote: using 2003. I need to capture the outline level and or if columns/ rows have been grouped. I know how to set the outline level but how can I capture if/what the outline level is? meg99 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to promote/demote Excel rows to new outline group level? | Excel Discussion (Misc queries) | |||
Resetting view when hiding detail in outline level | Excel Discussion (Misc queries) | |||
Test for outline level of cell | Excel Worksheet Functions | |||
In a formula how can I reference the outline level of a row? | Excel Worksheet Functions | |||
Macro to Outline based on Indent Level | Excel Programming |