Thread: How to use ActiveCell to mean a particular cell?
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 use ActiveCell to mean a particular cell?
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

Reply With QuoteReply With Quote