Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Under data/Group&outline/group | Excel Discussion (Misc queries) | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |