Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looping till condition is satisfied?
I have this macro's code:
Dim SCell As Integer Do Until SCell.Value = 1 If SCell.Value < 1 Then Range("J24").Select Calculate End If Loop Where SCell has a formula like this: "if (A2<A3,1,0)" and A2 has a random number while A3 is a fixed value. I want the macro once clicked to keep changing A2 till SCell formula is 1. So the loop could run 5 times or 500 times. Is there something wrong in the code above? Thanks, Jo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping till value is 1? | Excel Discussion (Misc queries) | |||
How to change the value of a cell when a condition is satisfied, but not otherwise? | Excel Discussion (Misc queries) | |||
SUM C IF B=Cap... Till Next B=Cap... | Excel Worksheet Functions | |||
SUM C IF B=Cap...TILL NEXT B=Cap... | Excel Worksheet Functions | |||
Deletion of rows where a value is satisfied | Excel Worksheet Functions |