covar function

[jcher]

Hi,

i'm trying to write the following line in my excel/vba macro

covar(D6:D55,D6:D55)

i get the error message "Expected list separator or )"

Please advise. This expression works in the spreadsheet. I don't know why the VBA compiler complains about it.

 

[Andrew Poulsom]

Like this?

x = WorksheetFunction.Covar(Range("D6:D55"), Range("D6:D55"))