How to use ActiveCell to mean a particular cell?
Jo,
How to use ActiveCell to mean a particular cell?
The activecell is the selected cell
Looking at your code unless calculate changes J24 its very likely you will
enter and endless loop. What in words are you trying to do?
Mike
"Jo" wrote:
Hi,
How can I make ActiveCell below refer to SCell?
Dim SCell As Integer
Do Until ActiveCell.Value = 1
Range("J24").Select
Calculate
Loop
Thanks,
Jo
|