View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rghpvf rghpvf is offline
external usenet poster
 
Posts: 1
Default How to trap the error message "Remote Data not accessible"?

I have tried to use IsError and On Error in VBA to trap the error
message "Remote Data not accessible" when a DDE program is not active,
but I keep getting the dialog box. I want to clear the active cell if
the program is not running. Any ideas?


---
Message posted from http://www.ExcelForum.com/