ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell value (https://www.excelbanter.com/excel-discussion-misc-queries/176877-cell-value.html)

steve

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

Don Guillett

Cell value
 
I'm not sure I understand. Why not just use

for i = 1 to 260
call mymacro
call mymacro1
next i


--
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




All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com