View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BlindGuardian[_2_] BlindGuardian[_2_] is offline
external usenet poster
 
Posts: 1
Default 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