excel - Limitation in counting down loop -

-

i have following simple excel spreadsheet:

                b              c 1                 10 2               =b1+a2 3             =summe(b1:b2) 4

in cell a2 counting down values inserted following macro:

sub test () sheets("sheet1").range("a2").value = sheets("sheet1").range("a2").value - 1 until sheets("sheet1").range("b3") > 0 sheets("sheet1").range("a2").value = sheets("sheet1").range("a2").value - 1 loop end sub

this works fine far. however, want limit loop in macro. should countdown numbers in cell a2 until reaches number 0. should never go below 0.

do have idea how can insert such "limit" in code?

it should never go below 0.

before writing value, check if <0 , exit do loop.

is want?

do until sheets("sheet1").range("b3") > 0     if sheets("sheet1").range("a2").value - 1 < 0 exit     sheets("sheet1").range("a2").value = sheets("sheet1").range("a2").value - 1 loop

Comments

Post a Comment

Popular posts from this blog

PHP while loop dynamic rowspan -

-
Image
consider table example using these table wanted print table these adding rowspan item id 1002. here php code $temp_val = ''; $counter = 1; $sql_sel = mysqli_query($con,"select * item_table"); while($res_sel = mysqli_fetch_array($sql_sel)){ if($temp_val == $res_sel['item_id']){ $counter++; echo "<tr></tr>"; } else{ echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; } $temp_val = $res_sel['item_id']; } echo "</table>"; it's not correct, it's adding rowspan item id 1003 you should switch code inside else , if statement
Read more

timer - Java TimerTask cancel -

-
i have following problem. every 2 seconds programm go inside if statement. inside if statement want have timer give me message after 15 seconds. timer should run delay of 1 second. while i'm "waiting" timer, if statement executed 7 times. problem is, have 7 same timertask @ same time running. how can solve problem? if (response == true) { final timer timer = new timer(); final int keepalivetimeout = 15000; //15 seconds timer.schedule(new timertask() { @override public void run() { if (response) { response = false; log.i(tag, "********response******"); timeoutcounter = 0; } else if (timeoutcounter > keepalivetimeout) { log.i(tag, "********timer timeout******"); } log.i(tag, "********timer******"); timeoutcounter = timeoutcounter + 1000; } }, 0, 1000); } from java api : public void schedule(timertask task, long delay, ...
Read more

android - How to read a column value in parse.com without accessing an object or a pointer -

-
by using code, not able 'name' unless use objectid = xj34weo . suggest way, if not, @ least using pointer. //parse query initialization final parsequery<parseobject> query = parsequery.getquery("myusers"); //to check row has "number"="1234" query.whereequalto("number", "1234"); query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null) { try { //xj34we0 objectid query.get("xj34weo").get("name") + ""); } catch (parseexception pe) {} } } }); are trying employee object number? you have list<parseobject> , use it. query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null && employ...
Read more