Converting variant return type from evaluate to integer

I would like to get the return value for an evaluate statement which is a variant data type, convert it to an integer and do some computation. I have 4 test programs, the first 3 all work, the 4ths does not.

The first sd_test(returns 1) and st_test1(returns 1) demonstrate that my evaluate statement is correct and works,

sd_test2(returns 3) shows that I can convert a variant to an integer

in sd_test3(returns #VALUE!) I try to put both together and it doesn't work?
any help? thanks paul

Please Login or Register  to view this content.

Hi

I expect Evaluate is returning an array so you need to reference the array element to pass to the CInt function:

Please Login or Register  to view this content.

Richard

Variants can hold arrays - the code works for me once my amendment has been put through. Your table header row isn't in a row past 32767 is it?

If your compile error was a syntax error, did you use square brackets rather than standard ones? Richard's code is correct.

No worries - glad that's sorted.

Wish I was clever enough to be a C/C++ programmer!

Easy mistake to make!
(just a bit gallling to have to admit Richard was right... )

Originally Posted by romperstomper

(just a bit gallling to have to admit Richard was right... )

Cheeky bugger!