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