Application.ScreenUpdating parameter doesn't work

[grizzlybear]

Hi,

I am trying to run a macro in the background. I have added the Application.ScreenUpdating = False (and True at the end) to my code but no luck. Any ideas?

 

[goldfish]

TestValue won't change on each iteration because you have not placed it in the loop. Place it after the "Do Until" to get it to change each time through the loop.

When you say "this code won't update the table", do you mean the if statement is never successful? Like if you add

Msgbox "Woot, it works!"

after the line:

If TestValue = CheckValue Then

Do you ever see the message box?

~Gold Fish

 

[grizzlybear]

Gold fish,

What I mean is that this value "Mid(RNG.Value, 2, 2)" doesn't change after the first iteration. Therefore the statement is never going to be true. It get the value "10" from the seed value "R10" the first time through, then holds that value. On the next interation it should change to "12" from the seed value "R12" etc. Placing the TestValue variable in the code was simply a way of seeing what value was in Mid(RNG.Value, 2, 2)". It doesn't change whether it is before or after the Do Until statement because the "Mid(RNG.Value, 2, 2)" value doesn't change.

Cheers
GB