Run Macro until a condition is met

[tx12345]

Hi

Let's say I have a little macro that generates a short random row of
numbers. In another cell there is a formula that sees if a particular
condition is met with the lately created string by the marco.

The next item of business is to store the string *if* the condition is
met.

But let's say I need my 'storage' list to have at least 20 rows of
qualified strings, assuming not every string evaluated will qualify for
storage.

Is there a way to tell the macro "keep going until there are 20 rows of
data"?

Thx


tx

 

[Don Guillett]

Look in vba help index for LOOP. try something like

do until counter =20

loop

 

[tx12345]

OK, i've got:

Sub store

Do counter = 20

Application.Run "xzy!store1"

loop

end sub

but it runs on into infinity. any way to tell it to stop when Cell C1
for example, says 20?

thx

t