Posted to microsoft.public.excel.programming

Antonio

external usenet poster

Posts: 134

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protect Sheet Error	Kcope8302	Excel Worksheet Functions	0	December 18th 08 03:38 PM
Macro sheet by sheet error	Daniel R. Young	Excel Programming	2	October 12th 05 01:35 AM
Error when moving sheet	mihai[_5_]	Excel Programming	2	November 9th 04 03:14 PM
Sheet protection error msg - Unrequested sheet activation	deltree[_3_]	Excel Programming	0	January 28th 04 06:20 PM
Error 91 but only when sheet is protected	Limey1971	Excel Programming	2	January 22nd 04 10:27 AM

All times are GMT +1. The time now is 06:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us