Yes I am looking for a test (boolean) to see IF is has a dependent,
What I am doing is testing to see which cells in my spreadsheets ar
inputs. The test will say:

If Hasprecedents(Range) = FALSE And If Hasdependenets(Range) = TRU
Then
IsInput = TRUE

I was using your code to do the dependent part of the test.

Thn

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=27618