ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007; OutlineLevel-Problem (https://www.excelbanter.com/excel-programming/405001-excel-2007%3B-outlinelevel-problem.html)

Tom

Excel 2007; OutlineLevel-Problem
 
Hi,

It seems that Excel 2007 has some problems with the OutlineLevel-property.
When I run the follwing code

Sub Test()
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets(1)
With ws.Range("A2:A10").EntireRow
.Rows.Group
.OutlineLevel = 1
End With
End Sub

a very annoying beep is sounded. Does anybody know how to solve this
(simple) issue?

Tom



All times are GMT +1. The time now is 08:06 AM.

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