Loops and Events
Hi,
Does anyone know how to do the following :
I want to execute a procedure/sub over and over again repeatedly, but *only*
if a particular cell in Excel is set to, say, "Y". I have tried using a
simple loop (Do ... Loop Until etc.) but while this runs the code as wanted,
it completely locks up Excel and stops you from doing anything to the cells
etc. In other words, there is no way of stopping the code. Also, if I can
get this principle working then I can also have other adjustable parameters
for the code using other cells.
Any ideas?
Thanks,
Tom
|