| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Calculating average problem
Hi all,
I need to calculate an average in VBA excel. I know only this form of calculation: Worksheets(2).Cells(3, 2).Value = "=Average(Sheet1!C3:C137)" But I need to calculate this for few columns and rows, hence I want t use a loop. But I don't know how to write this formula with a variabl inside. Help me, please, Len -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Average | Excel Discussion (Misc queries) | |||
| Excel Calculating problem | Excel Discussion (Misc queries) | |||
| microsoft excel 2000 calculating problem | Excel Discussion (Misc queries) | |||
| Calculating the average | Excel Discussion (Misc queries) | |||
| Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
