Tim,

Thanks for the response.

What I'm trying to do is get the variable s to equal the value that is
returned by the defined name "Set_Size".

The problem is the variable r is an integer and the Refers to: field of
the defined name "Set_Size" contains a formula (which makes it a string
value).

A type mismatch occurs because the IF statement is comparing two
different data types.

What's the best way to get the variable s to equal the integer value of
the "Set_Size" name ?


kittronald