Thread: Range.Average Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Range.Average Problem
Change

LCV.WorksheetFunction.Average

to

WorksheetFunction.Average

HTH,
Barb Reinhardt
"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)))
Reply With QuoteReply With Quote