| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write an average formula from VBA- SHOULD BE SIMPLE!
Two ways: Sub AverageThem1() x =WorkSheetFunction.Average(Range("b4"), Range("e6")) MsgBox x End Sub Or to write Average Formula to WorkSheet cell, say Range F2 Sub AverageThem2() Range("F2").Formula="=Average(b4,e6)" End Su -- david ----------------------------------------------------------------------- davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064 View this thread: http://www.excelforum.com/showthread.php?threadid=47501 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write formula for simple copy and paste to another cell | Excel Worksheet Functions | |||
| Calculated field in pivot table, simple Average formula | Excel Discussion (Misc queries) | |||
| Help I need to know how to write a simple formula, not having any | Excel Discussion (Misc queries) | |||
| simple average formula...can you solve it in principle? | Excel Discussion (Misc queries) | |||
| How to write an average formula from VBA- SHOULD BE SIMPLE! | Excel Programming | |||
Hybrid Mode
