Thread: Checking cell for Dependents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_182_] ExcelMonkey[_182_] is offline
external usenet poster
  
Posts: 1
Default Checking cell for Dependents

I was hoping that there would be dependent properties that I could test
TRUE or FALSE. It looks as though the examples you have are methods.
Is it possible to test the method to see if it fails. That is if i
you go

cell.dependents.select

and there are not any dependents will the code fail. If so, can I tra
the error and pass this to a TRUE FALSE variable.

Thanks

R

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

Reply With QuoteReply With Quote