Try this: voltage = Application.WorksheetFunction.Average(Range("B1:B" & i))
voltage = Application.WorksheetFunction.Average(Range("B1:B" & i))
Consulting Services :|: Excel VBA Training and Certification :|: What is a Microsoft MVP? :|: Set Your country/state Flag
Forum Rules
Posting Permissions
Reply With Quote