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

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

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?

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?

Jo" wrote in message
ups.com...

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


Replace @mailinator.com with @tiscali.co.uk


"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?

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....



Jo wrote:

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?

--

Dave Peterson