Range.Average Problem
I don't know what LCV is a reference to, but I suspect
LCV.Range doesn't point where you think it does
or
LCV.Range is blank
or
LCV.Range
doesn't contain any numbers (or contains numbers that are stored as text
strings).
if you try using Average in a cell going against the range you want averaged
and get a valid answer, then you can disregard the stored as strings.
--
Regards,
Tom Ogilvy
"NewToVB" wrote:
I'm trying to average I3:I & c + 2
but I keep getting zeros. Any ideas why?
CSVCICAvg = LCV.WorksheetFunction.Average(LCV.Range("I3:I" & (c + 2)))
|