LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Code execution has been interrupted

I know this question has been asked before, but I don;t see a resolution.

The code runs OK as long as I keep hitting the continue button.


I already have

Application.DisplayAlerts = False

I've tried shutting off and re-booting, still with same problem.
On Error Resume next does not bypass the problem and it pops up at random
places in the code.

I wonder if it is a memory or display processor problem, wher eth erest of
the sytem can't keep up. I have tried to release variable whn I'm done with
them, but that has been throwing errors, too.

What is wrong with BidRate() = nothing after I'm done with it that would
throw an error?

In the past I have sometimes defeated this by putting a pause at the end of
loops to let things catch up.

Any other ideas?

My code uses some pretty big arrays to copy data and reformat it to another
display sheet.

Actually, it does not copy the data, but copies the address and puts a
forrmula pointing to the data in the display sheet. (government requirement).
Do thousands of formulas gum up the works faster than thousnds of data points?




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Code Execution Has Been Interrupted Carroll[_3_] Excel Programming 3 December 5th 07 02:05 PM
Code Execution Has Been Interrupted? alondon Excel Programming 0 March 4th 07 05:52 PM
Code Execution has been interrupted - ?? ina Excel Programming 4 June 15th 06 04:48 PM
Code Execution Has been Interrupted Adrian[_7_] Excel Programming 0 July 30th 04 10:02 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"