Cell Value

[steve]

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

 

[Don Guillett]

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

 

[JLGWhiz]

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]

Awesome thanks



Steve

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