ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Outline level (https://www.excelbanter.com/excel-programming/395596-outline-level.html)

meg99

Outline level
 
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

Outline level
 
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


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com