And you think it helps to post a new thread instead of continuing the old
one? That's a bad mistake since multiposting is not popular nor should it
be.


--


Regards,


Peo Sjoblom



"Jo" wrote in message
ups.com...
On Oct 4, 2:41 pm, Dave Peterson wrote:
Check your other threads.

If you keep the discussion in one thread, then you may find that you get
better
answers.

Jo wrote:

I have this macro:

Dim SCell As Integer

Do Until ActiveCell.Value = 1
Range("J24").Select
Calculate
Loop

SCell hits "1" yet it keeps running!? I am wondering how to make
ActiveCell refers to SCell?

Jo

--

Dave Peterson

I am forced to do so because non of the answers I am getting is
working! Put yourself in my shoes?