Cell Value
 

Hi all


I have a value in cell A1 of 1
now i want to run various macroes
then i want the value to A1 to increase by 1 to 2
then run the same macros
and so on and son on

when the value of A1 is 260 then stop



any idea's on this one please


cheers



Steve

Cell Value
 

Pls post in ONE group only. See ans in other post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"steve" wrote in message
...
Hi all


I have a value in cell A1 of 1
now i want to run various macroes
then i want the value to A1 to increase by 1 to 2
then run the same macros
and so on and son on

when the value of A1 is 260 then stop



any idea's on this one please


cheers



Steve

Cell Value
 

Psuedo code would run three macros until Range("A1").Value = 10.

Sub AddOne()
Range("A1").Value = 1
Do While Range("A1").Value < 10
Macro 1
Macro 2
Macro 3
Range("A1").Value = Range("A1").Value + 1
Loop
End Sub


"steve" wrote:

Hi all


I have a value in cell A1 of 1
now i want to run various macroes
then i want the value to A1 to increase by 1 to 2
then run the same macros
and so on and son on

when the value of A1 is 260 then stop



any idea's on this one please


cheers



Steve

Cell Value
 

Awesome thanks



Steve








JLGWhiz wrote:
Psuedo code would run three macros until Range("A1").Value = 10.

Sub AddOne()
Range("A1").Value = 1
Do While Range("A1").Value < 10
Macro 1
Macro 2
Macro 3
Range("A1").Value = Range("A1").Value + 1
Loop
End Sub


"steve" wrote:

Hi all


I have a value in cell A1 of 1
now i want to run various macroes
then i want the value to A1 to increase by 1 to 2
then run the same macros
and so on and son on

when the value of A1 is 260 then stop



any idea's on this one please


cheers



Steve