| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate Min and Max Values of selection
HI
I have a range selected as following: Range(ActiveCell, ActiveCell.Offset(NumMeasPerPix - 1, 0)).Select How can I do calculations with the data in that selection e.g. get the Min or Max Value or the Mean Value? Those are all available in Excel. How can I make them available programatically? Is it possible to store the result in a different worksheet? How? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Combo box selection will not calculate | Excel Worksheet Functions | |||
| Combo box selection will not calculate | Excel Discussion (Misc queries) | |||
| Calculate average based on user selection | Excel Discussion (Misc queries) | |||
| What first - sheet_change, calculate,selection, etc. | Excel Programming | |||
Threaded Mode
