Can VBA determine if a cell/range is in a group?

**BlindGuardian** · 06-10-2005, 01:20 PM

I'd like to find if a selected cell is within a group. Is this possible from VBA?

**Ron Coderre** · 06-10-2005, 01:49 PM

A Group?
Do you mean is the active cell part of a selection of several cells?

Regards,
Ron

**BlindGuardian** · 06-10-2005, 02:15 PM

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.

**Ron Coderre** · 06-10-2005, 02:24 PM

I think this may work for you: OutlineLevel

It will return 2, or more, if grouped in an outline. 1 if not outlined.

Please Login or Register  to view this content.

Does that help?

Ron

**BlindGuardian** · 06-10-2005, 02:35 PM

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.

**Ron Coderre** · 06-10-2005, 02:36 PM

You're very welcome. I'm glad that worked for you. Thanks for updating me

Regards,
Ron

ben · 06-10-2005, 03:05 PM

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
>
>

Chip Pearson · 06-10-2005, 03:05 PM

You can use the Intersect method to determine whether a cell is
in another range of cells. For example,

Please Login or Register  to view this content.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"BlindGuardian"
<BlindGuardian.1qf9yd_1118426712.4717@excelforum-nospam.com>
wrote in message
news:BlindGuardian.1qf9yd_1118426712.4717@excelforum-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
>