so Releasing all the variables as I go along didn't help.

The code runs, but only so long as you keep hitting the continue button.



"Jacob Skaria" wrote:

what is bidrate()

= Nothing returns an error if this is not an object.
If this is an array use Erase or ReDim

If this post helps click Yes
---------------
Jacob Skaria


"Hydra" wrote:

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?