Hi

That's exactly what my response was supposed to do!! I obviously
misunderstood your post. What do you want to use your variable/constant
for - once set? In the example you posted back - what output would you
expect to see?

Andy.

wrote in message
oups.com...
Hi,

Thanks for your reply.

I tried your suggestion and got the following:

B C
1 1
2 1 1
3 1 2
4 1 3
5 1 0
6 1 1
7 1 2

Unfortunately, once the "zero" condition is met, it causes the
condition checking to re-start.

What I am really after is a way to "store" or "set" a variable/constant
in Excel that, once set, remains set until actively un/re-set.

As an old DOS person, I see it as just like a DOS environment variable.

Any ideas?

Geoff.