How To: Is a Row a Group Row

K

Kevin McCartney

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
 
K

Kevin McCartney

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
 
A

arno

Hi Kevin,
What I need to do is to see if a Row is all ready a Group Row in that is
Click to expand...
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
 
Top