#Value in array causing Type Mismatch in comparision

Hi,

I have an array of numbers which was obtained from col-A of the enclosed input file. To keep things simple there are only 15 entries in the column. However, there is "#Value!" entry in row 6.

My goal is to "do something" if the number is greater than 25 and to do something else if its less than 25. The problem is that when making the comparison i get a "TypeMismatch" error.

Any ideas how to solve this?

To add some species to Norie's code.

Please Login or Register  to view this content.

thanks ....... guess i need to check if its an error first........