Code won't work "as single"

[kevincoxshall]

Please Login or Register  to view this content.

Dear all

Above is a line of my code that calculates the "Pearson" function from 2 files.
I'd like my variable to be defined "as single" but it causes an error unless I define "variable" as a string.

Please help

Kevin

[mrice]

If you are attempting to evaluate the function, you should try using

Variable = WorksheetFunction.Pearson(Array1,Array2)

You might need to use the INDIRECT function to define your arrays.

[mrice]

Please Login or Register  to view this content.

Fuller example

[Norie]

Kevin

Try this.

Please Login or Register  to view this content.

PS You should probably declare variable as Variant in case of error.

[kevincoxshall]

Thanks for all the replies.
mrice ta for your code it works but the files need to be open to work it.
Norie thanks I got your code to work perfect.
I am very pleased
thanks
kevin