| 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?
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 |
|
#3
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 | |||
Hybrid Mode
