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?