Code won't work "as single"

variable = ("=PEARSON(" & myfile1 & "!$F$1:$F$1000," & myfile2 & "!$F$1:$F$1000)")

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

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.

Sub Test()
Dim Variable As Single
Variable = WorksheetFunction.Pearson(Workbooks("Book2").Sheets(1).Range("A1:A16"), Workbooks("Book4").Sheets(1).Range("A1:A16"))
End Sub

Fuller example

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