Thread: How to make this macro stop?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo[_2_] Jo[_2_] is offline
external usenet poster
  
Posts: 69
Default 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

Reply With QuoteReply With Quote