How to create a array which holds decimal values

[Karthik Sen]

How to create a array which holds decimal values and check whether a value is present in that array using VBA

For ex :

If the value for a variable x lies between 1.2.3.1 to 1.2.3.50 then i should be getting a message stating "Good"...
If the value of the variable is not in the above list ( ex - say 1.2.3.56), then the msgbox should be "Not available"..

Values which will be entered are decimal points like given above..

[Norie]

This will create a one-dimensional array with the values 1.2.3.1, 1.2.3.2, ..., 1.2.3.50.

Please Login or Register  to view this content.

You can then use Application.Match to check if a value is in the array.

Please Login or Register  to view this content.

[Karthik Sen]

Hi, I am getting a Type mismatch error, when i try the above code.

[Norie]

Can you post your code and indicate where it errors?