Mark thank you,
The case I am having is different , I just give a simple example of what I am trying to accomplish.
your suggestion work for small numbers , however if I have to compare against big numbers like
If J < 10000 Then ...
there is no nasty solution for a Case statement.
in VBA it is possible by using IS before the conditional operand , something like Case is < 1000 will do.
apparently VBS. has limitations.
"I realize it's an error, but no one is going to try to do that!"
From "Top 10 Stupid Comments from Developers".