View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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