If the object is to simplify coding (ie make it less prone to typing
errors) there are several ways of doing this but you have not provided
any wider cntext for the issue so it is difficult to advise.

Options include:
- using select statements
- writing a functions that returns a true/false and does the test
internally
- use a class module in a similar way

I have used all these methods in various circumstances.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=548020