Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
I'd like to find if a selected cell is within a group. Is this possibl from VBA -- BlindGuardia ----------------------------------------------------------------------- BlindGuardian's Profile: http://www.excelforum.com/member.php...fo&userid=2420 View this thread: http://www.excelforum.com/showthread.php?threadid=37813 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
Hi Ron, In my case, I have several rows that have been grouped in an outline i.e. a grey bar appears on the left with "+" and "-" characters that allow me to expand and collapse the rows which belong to the group. The visibility of these can change by setting the Tools -- Options... -- View (tab) -- Outline symbols (checkbox). What I want to know is if my selection is currently within one of those rows which is in a group. I have not been able to find anything using Excel/VBA help to discover a property that seems to indicate whether a cell is part of a group or not. The nearest I've seen is IndentLevel but that always returns 0. Thanks for taking the time to respond. -- BlindGuardian ------------------------------------------------------------------------ BlindGuardian's Profile: http://www.excelforum.com/member.php...o&userid=24202 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
IF you mean is the active cell selected part of a NAMED RANGE or another
group of somehow defined cells, then yes Look up vba help for the INTERSECT property -- When you lose your mind, you free your life. "Ron Coderre" wrote: A Group? Do you mean is the active cell part of a selection of several cells? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
You can use the Intersect method to determine whether a cell is
in another range of cells. For example, Dim Rng As Range Set Rng = Range("A1") If Not Application.Intersect(Rng, Range("A1:A10")) Is Nothing Then ' Rng is in A1:A10 Else ' Rng is not in A1:A10 End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BlindGuardian" wrote in message news:BlindGuardian.1qf9yd_1118426712.4717@excelfor um-nospam.com... I'd like to find if a selected cell is within a group. Is this possible from VBA? -- BlindGuardian ------------------------------------------------------------------------ BlindGuardian's Profile: http://www.excelforum.com/member.php...o&userid=24202 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
I think this may work for you: OutlineLevel It will return 2, or more, if grouped in an outline. 1 if not outlined. Sub Test() Dim IsGrouped As Boolean IsGrouped = (ActiveCell.Rows.OutlineLevel 1) MsgBox "Grouped: " & IsGrouped End Sub Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
Previously when I tried ActiveCell.OutlineLevel I kept getting an error that it could not retrieve the property from the object. Now I see that OutlineLevel is a property that must be applied for a Rows object. Thanks very much for your help, Ron. -- BlindGuardian ------------------------------------------------------------------------ BlindGuardian's Profile: http://www.excelforum.com/member.php...o&userid=24202 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
You're very welcome. I'm glad that worked for you. Thanks for updating me Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=378137 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA determine if a cell/range is in a group?
Ron has pointed me in the right direction -- BlindGuardia ----------------------------------------------------------------------- BlindGuardian's Profile: http://www.excelforum.com/member.php...fo&userid=2420 View this thread: http://www.excelforum.com/showthread.php?threadid=37813 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use active cell to determine range | Excel Discussion (Misc queries) | |||
Value of cell to determine range in MAX Function | Excel Worksheet Functions | |||
Determine if Cell Address is within a Range | Excel Worksheet Functions | |||
Can VBA determine if a cell/range is in a group? | Excel Programming | |||
I need to determine a cell range based on a blank cell | Excel Programming |