Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Mm..how to write average worksheet function in VBA? worksheetfunction.average?
How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Hi
msgbox application.worksheetfunction.average(Range("C3:C9 ")) -- Regards Frank Kabel Frankfurt, Germany "KiriumF1" schrieb im Newsbeitrag ... Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
dblAvg = WorksheetFunction.Average
(Worksheets("Sheet1").Range("C3:C9").Value) -- Regards, Tom Ogilvy "KiriumF1" wrote in message ... Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Do to write the below in VBA? I used
Range("C4").Select Range("c4") = WorksheetFunction.Average(Range("M3:M9")) Range("C4").Select Selection.AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault Range("C4:I4").Select ----------------------------- in C4: =AVERAGE(M3:M9) then copy across to I4 -------------------------------------------- "KiriumF1" wrote: Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Worksheetfunction.Average(Worksheets("fulldata for c1").Range("A1:G1"))
-- HTH RP (remove nothere from the email address if mailing direct) "KiriumF1" wrote in message ... Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Do to write the below in VBA? I used
Range("C4").Select Range("c4") = WorksheetFunction.Average(Range("M3:M9")) Range("C4").Select Selection.AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault Range("C4:I4").Select ----------------------------- in C4: =AVERAGE(M3:M9) then copy across to I4 "Tom Ogilvy" wrote: dblAvg = WorksheetFunction.Average (Worksheets("Sheet1").Range("C3:C9").Value) -- Regards, Tom Ogilvy "KiriumF1" wrote in message ... Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Sub AA()
Range("c4").Formula = "=Average(M3:M9)" Range("C4").AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault End Sub -- Regards, Tom Ogilvy "KiriumF1" wrote in message ... Do to write the below in VBA? I used Range("C4").Select Range("c4") = WorksheetFunction.Average(Range("M3:M9")) Range("C4").Select Selection.AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault Range("C4:I4").Select ----------------------------- in C4: =AVERAGE(M3:M9) then copy across to I4 "Tom Ogilvy" wrote: dblAvg = WorksheetFunction.Average (Worksheets("Sheet1").Range("C3:C9").Value) -- Regards, Tom Ogilvy "KiriumF1" wrote in message ... Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function?
Sub AA()
Range("c4").Formula = "=Average(M3:M9)" Range("C4").AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault End Sub -- Regards, Tom Ogilvy "KiriumF1" wrote in message ... Do to write the below in VBA? I used Range("C4").Select Range("c4") = WorksheetFunction.Average(Range("M3:M9")) Range("C4").Select Selection.AutoFill Destination:=Range("C4:I4"), Type:=xlFillDefault Range("C4:I4").Select ----------------------------- in C4: =AVERAGE(M3:M9) then copy across to I4 -------------------------------------------- "KiriumF1" wrote: Mm..how to write average worksheet function in VBA? worksheetfunction.average? How do I reference to the range of cells in another worksheet? Is it like this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Function | Excel Discussion (Misc queries) | |||
Worksheet Function | Excel Worksheet Functions | |||
Is there a worksheet function that will... | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions |