| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple macros question
Thanks, I'll give it a try.
"Martin Krastev" wrote: Let's say that the cell where you put the first average is "B1" You have a macro function getAverage then try the following dim avg as double dim r as integer dim cB1 as range set cB1 = range ("B1") for r = 1 to 100 avg=getAverage cB1.Offset(r,0).value=avg next r "Eric M." wrote: I have written a short macros to sample and average data sets and post the average to a separate cell. I have the macros to repeat 100 times, 100 averages, but don't know how to have it post each average to a progressive cell. In other words, post the first average to one cell, then index down for the next average and next,... till there is a list of 100 averages. After that, I will do more with the data, but need to get by this step first. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| simple question about macros | Excel Programming | |||
| Learning Macros and ActiveX controls...have a simple question... | Excel Programming | |||
| simple question, hopefully a simple answer! | Excel Programming | |||
![Eric M.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
