View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default If sheet has no #N/A error then...

I have a large sheet with plenty of DDE links to a market data server.

Depending of the link status and other conditions the sheet updates all the
links after variable lengths of time.

While a link is not updated the cell shows #N/A

Is there a way to quickly check that all DDE links have been updated?

I can check that every cell is not error but that is not good enough.

Thanks,

Antonio