Stopping a Looping Macro
Can someone please help this complete newbie where macros & VBA are
concerned?
I've obtained a macro from the web which does exactly what I was looking for
but I now need to tweak it a bit.
[for info: it generates random numbers in certain cells]
a) I would like it to *loop* until certain criteria are met e.g. "A1=7"
_and_ "B1 20"
b) I would also like to be able to stop it manually [e.g. by pressing a
certain key] to prevent it going into a permanent loop.
BTW I'm using Excel 2002
Any help appreciated
TIA
Tony
|