Outline level

  • Thread starter Thread starter meg99
  • Start date Start date
M

meg99

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
 
For any given row?

Dim myRow As Range
Set myRow = ActiveSheet.Range("a17").EntireRow
MsgBox myRow.OutlineLevel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

outline question 1
Trapping expansion or collapse of outlines 1
Re-post: Outline Event 5
Outlining with condition? part 2 7
FIND ALL 1
Are there any events for outlines functionalities? 2
Macro to Outline based on Indent Level 3
Outline, expand or collapse via VBA 1

Back
Top