How can I find out the maximum Outline Rowlevel?

W

Wassim

Hi!

My problem is the following:

I can display certain Rowlevels by using this command:

ActiveSheet.Outline.ShowLevels RowLevels:=2

But I want to find out how many rowlevels there are.
Does anybody have any clue about this?

Thank you in advance!

Wassi
 
D

Dave Peterson

See one response at your other post.

Wassim < said:
Hi!

My problem is the following:

I can display certain Rowlevels by using this command:

ActiveSheet.Outline.ShowLevels RowLevels:=2

But I want to find out how many rowlevels there are.
Does anybody have any clue about this?

Thank you in advance!

Wassim
Click to expand...
 

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

Slow VBA code....Hide/Unhide Loop 2
2002 vs 2007 MS Office Excel has encountered a problem and needs t 2
Excel not showing steps as I F8 through each line of VBA code 1
Excel 2003 macro won't run in Excel 2007 5
Macro Problem 1
Macro for Costing 0
Macro Opening or Looking for Another Workbook 6
Expanding the outline of one subtotal 1

Top