function on a range
Hi all
here's my problem
I want to apply a function (ex: average) on a range of data
So I wrote
Dim A as Rang
Set A = Range("A1:A10"
Range("B1").FormulaR1C1 = "=AVERAGE(A)
but it's wrong (#NAME? as error)
I tried with "FormulaLocal" and "Formula", bu
is always wrong
I want to use a range because the range will change every day
How can I do
Thanks a lo
sincerel
|