Array

[EscapeUK]

How do I go through an array checking the values to see if any match a value I have stored in a variable. or until i reach the end of it.

ta

 

[Hackster]

Try something along these lines:

For i = LBound(ArrayName, 1) To UBound(ArrayName, 1)
If Val(ArrayName(i, 1)) = WhatYouAreSearchingFor Then
DoSomethingCool
Endif
Next

 

[SIG357]

There's a function UBound() that takes the array as an argument and returns the highest index in that array. You can use that to determine how many times to loop and conpare