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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
function on a range
You need
Range("B1").Formula = "=AVERAGE("A1:A10")" that is a string, not a range object -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "pippo&menelao" wrote in message ... 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 Range Set A = Range("A1:A10") Range("B1").FormulaR1C1 = "=AVERAGE(A)" but it's wrong (#NAME? as error). I tried with "FormulaLocal" and "Formula", but is always wrong. I want to use a range because the range will change every day. How can I do ? Thanks a lot sincerely |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
function on a range
Hi bob
you probably meant: Range("B1").Formula = "=AVERAGE(A1:A10)" -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... You need Range("B1").Formula = "=AVERAGE("A1:A10")" that is a string, not a range object -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "pippo&menelao" wrote in message ... 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 Range Set A = Range("A1:A10") Range("B1").FormulaR1C1 = "=AVERAGE(A)" but it's wrong (#NAME? as error). I tried with "FormulaLocal" and "Formula", but is always wrong. I want to use a range because the range will change every day. How can I do ? Thanks a lot sincerely |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
function on a range
Mixing my worksheets and VBA.
Thanks Frank. Bob "Frank Kabel" wrote in message ... Hi bob you probably meant: Range("B1").Formula = "=AVERAGE(A1:A10)" -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... You need Range("B1").Formula = "=AVERAGE("A1:A10")" that is a string, not a range object -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "pippo&menelao" wrote in message ... 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 Range Set A = Range("A1:A10") Range("B1").FormulaR1C1 = "=AVERAGE(A)" but it's wrong (#NAME? as error). I tried with "FormulaLocal" and "Formula", but is always wrong. I want to use a range because the range will change every day. How can I do ? Thanks a lot sincerely |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
function on a range
Hi Bob
know this :-) still not enough coffee this day <vbg -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... Mixing my worksheets and VBA. Thanks Frank. Bob "Frank Kabel" wrote in message ... Hi bob you probably meant: Range("B1").Formula = "=AVERAGE(A1:A10)" -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... You need Range("B1").Formula = "=AVERAGE("A1:A10")" that is a string, not a range object -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "pippo&menelao" wrote in message ... 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 Range Set A = Range("A1:A10") Range("B1").FormulaR1C1 = "=AVERAGE(A)" but it's wrong (#NAME? as error). I tried with "FormulaLocal" and "Formula", but is always wrong. I want to use a range because the range will change every day. How can I do ? Thanks a lot sincerely |
Reply |
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 |