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