I actually want to be able to test for dependents and precedents o
other sheets. effectively my models have inputs like all models.
want to be able to test to see which cells are inputs in the entir
spreadsheets. I will eventually past the cell address of these onto
summary page as a hyperlink. I have the paste as hyperlink piec
figures out but cannot seem to figure how to identify if in fact a cel
is an input.

So yes, it will be deemed an input if it does not have precedents an
of course it has to have dependents. AlL i need is a boolea
true/false and I am on my way. But I will need it to go beyond th
sheet that the cell is in.

Th

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