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!