Both Select Case and Like operators are powerful and extremely useful commands in VBA language , but under normal circumstances, they don't work together. In this article you will learn how to ...

Here's the problem Simplified.<P>I have a integer(x) which I need to compare against a various ranges for action. If I use regular VB, I would do something like this ...

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...