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 |
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 |
How to use ActiveCell to mean a particular cell?
On Oct 4, 3:13 pm, Mike H wrote:
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- Hide quoted text - - Show quoted text - Thanks Mike, I found it....... |
How to use ActiveCell to mean a particular cell?
Jo,
SCell is a number variable, not a cell variable. Anyway, it is totally superfluous. The code loops until miraculously the Activecell becomes 1. Unless you have some sort of feeding updating J24 it never will. What exactly do you want to do? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jo" wrote in message oups.com... 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 |
All times are GMT +1. The time now is 10:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com