Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Range | Excel Worksheet Functions | |||
DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
range function | Excel Discussion (Misc queries) | |||
How do I set up a range within a IF function? | Excel Worksheet Functions | |||
Range function | Excel Worksheet Functions |