Convert array element to a number

[Gandalf2524]

I capture data in an array dimensioned as Variant and want to compare an element of the array to a number. How do I convert a single element of the array to a number? For example my array is filled like so

"150-30041", "1", "C356"
"150-30082", "1", "C706"

The 2nd element of each row is a count. I want to compare this value to a number on an open worksheet. I tried a simple

Please Login or Register  to view this content.

where (row_n, col_n) specifies the cells to compare. However, this fails because the array element is treated as text.

Any thoughts?

[Norie]

There are various converion functions you can use - Val, CLng, CInt, CSng, CDbl.

For example.

Please Login or Register  to view this content.

[Gandalf2524]

Thanks Norie, that solved my problem.