Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to return an average value for a variable range of cells using this line of code:
rangeavg = WorksheetFunction.Average(Range(n1 & o1 & ":" & n1 & o2)) The values in the range have up to 3 decimal places, and the "rangeavg" variable is defined as "Long" but the routine keeps returning the average as an integer value. I need it to maintain the decimal place data. Am I missing something in this line of code or the variable definition or something? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
average with out rounding up in a group of cells | Excel Worksheet Functions | |||
Unwanted Rounding | Excel Discussion (Misc queries) | |||
help with rounding up to whole integer | Excel Discussion (Misc queries) | |||
Rounding to nearest integer | Excel Worksheet Functions | |||
Unwanted Rounding Errors | Excel Programming |