thanks randy, figured it was something simple. i knew i could use if statements,
but wanted to use select case.

--


Gary


"Randy Harmelink" wrote in message
oups.com...
When you say:

select case test

...you're telling VBA you want to do something based on values of the
variable called "test". Instead, you are giving it conditions.

When you want to specify conditions instead of values for each of the
Cases within the Select Case, your first statement should be:

Select Case TRUE

That tells VBA you are evaluating expressions instead of values for
each Case.