How To: Is a Row a Group Row

[Guest]

Hi
What I need to do is to see if a Row is all ready a Group Row in that is there a little plus sign all ready assigned to the row in that it is all ready grouped/outlined. How do I get this as a True or False value within VBA

TI
KM

 

[Guest]

The answer is if anyone is intereste

Range.Rows.Summary where Range is the range I want to look at

cia
K

----- Kevin McCartney wrote: ----

Hi
What I need to do is to see if a Row is all ready a Group Row in that is there a little plus sign all ready assigned to the row in that it is all ready grouped/outlined. How do I get this as a True or False value within VBA


TI
KM

 

[arno]

Hi Kevin,

What I need to do is to see if a Row is all ready a Group Row in that is

there a little plus sign all ready assigned to the row in that it is all
ready grouped/outlined. How do I get this as a True or False value within
VBA?

Try this:

Sub test()
Cells(1, 1).Value = ActiveCell.Rows.OutlineLevel
End Sub

arno