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!

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!

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!

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!

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!

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!

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!

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!