How to make this macro stop?
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 |
How to make this macro stop?
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 |
How to make this macro stop?
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? |
How to make this macro stop?
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? |
How to make this macro stop?
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? |
How to make this macro stop?
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 |
All times are GMT +1. The time now is 08:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com