Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First, I am surprised the following alone does not work when there are
no dependents: dim dep as Range for each dep in cell.Dependents [....] next dep Normally, the For statement works just fine when it has nothing to do. But okay, the above produces an error when there are no dependents ("no cells were found"). So what do I test to prevent the error? I thought: if cell.Dependents.Count 0 then for each dep in cell.Dependents [...] next dep end if But that does not work. I also tried IsNull() and IsEmpty(), to no avail. So, what's the correct magic incantation to use? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
survey traverse computations | Excel Discussion (Misc queries) | |||
traverse data based on 2 conditions | Excel Discussion (Misc queries) | |||
traverse until non integer | Excel Programming | |||
Checking cell for Dependents | Excel Programming | |||
Traverse treeview bottom to top | Excel Programming |