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


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=511963