Your code logic is based on ActiveCell, which is always going to be on
ActiveSheet. If you want to test the value of other cells on other
sheets you'll need to activate those sheets respectively, OR use a
fully qualified reference to them.

In your case a Select Case construct is *not* a good approach. Perhaps
if you better explain what it is you're trying to do people here will
be better able to offer help!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion