How to make this macro stop?

[Jo]

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]

Check your other threads.

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

 

[Jo]

Check your other threads.

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

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

 

[Peo Sjoblom]

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

 

[Sandy Mann]

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

So instead of answering some of the people who have tried to help you, you
start yet another new thread 13 minutes later!

Put yourself in our shoes.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave Peterson]

Just to add...

If you respond in the same thread with why a suggestion didn't work, it'll stop
you from getting the same (non-working) response over and over and over....