| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
