thanks for that - I did search for it, honest

cheers

-Griz

Hi JRL - thanks for your reply - but that's not what I'm after. What I was looking for is something like this

http://www.vbtutor.net/lesson8.html

cheers

-Griz

Is there something similar to "select case" in macro scheduler ro do i need to use nested "ifs"?

Basically I have one of 7 scenarios i want o check on and make a selection (set a variable) depending on which of the 7 is true.

cheers

Griz