Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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....... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
Which cell was the activecell before a keypress | Excel Worksheet Functions | |||
Activecell, not for cell,but for range? | Excel Discussion (Misc queries) |