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?