View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] angst987@gmail.com is offline
external usenet poster
 
Posts: 2
Default I'm getting unwanted rounding to integer for an average of range of cells.

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?