“DO Until” and “Do Unless”

[ibrahimaa]

I remember a formula named “DO Until” and “Do Unless”. If these formulas are not exist in the excel Windows 7, what its equivalents? How can I get I list with all its equivalents? I appreciate any help. Thank you. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[JackDanIce]

As far as I know, there's no such formula as DO UNTIL in any Excel version. VBA does have a loop structure called DO WHILE and may have DO UNTIL (I can't recall). Maybe this is what you're referring to.

 

[Ruddles]

There's certainly a Do Until in VBA, however I've been programming since 1978 and I've never seen a Do Unless in any language I've ever used - and that's quite a few.

How would you expect Do Unless to operate and where would you use it that Do While and Do Until wouldn't work equally well?

 

[JackDanIce]

Erm Ruddles, you probably will hate me for saying this.. you've been programming for longer than I've been alive!

 

[Ruddles]

Not at all!

That's not why I hate you...

 

[Weaver]

Has anyone ever used the do...if only... code construct?

 

[MrKowz]

Not at all!

That's not why I hate you...

Ruddles just hates everyone equally.

 

[JackDanIce]

Ahh Ruddles, I'm touched, truly!

Weaver - I think I have. Is that where it loops through a fixed range of data but only executes the code if the condition is met? So doesn't necessarily stop until it finishes looping?

 

[Ruddles]

PL/1, Fortran, COBOL, PMA, Algol 60, Pascal, Forth, Logo, JavaScript, PHP

Assemblers: 6502, 8080, Z80, two I'm not allowed to mention

Basics: GW, Sinclair, BBC, QuickBasic, Visual Basic, VBA

I can't believe that's all... I was sure I'd clocked up a couple of dozen at least!

 

[Ruddles]

Ruddles just hates everyone equally.

Ah, you saw my rant yesterday then?