G
Guest
All i need is to calculate a correlation of two ranges and assign it to a
variable. I tried this but i get an 91 error (object or with block not set):
dim correlation as range
Set correlation.Formula = "=correl(inSerie" & i & ",inSerie" & j & ")"
but, if i replace "correlation" by range("a1"), then it works fine.
variable. I tried this but i get an 91 error (object or with block not set):
dim correlation as range
Set correlation.Formula = "=correl(inSerie" & i & ",inSerie" & j & ")"
but, if i replace "correlation" by range("a1"), then it works fine.