Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation on a range problem
Hi
Need a little help please. Cells C3 to C7 contain these values. The e indicates an estimated score and so needs to remain with the number. 45 73 50e 29 88 After some help from Bob Phillips, I got Avv2 to work. Sub Avv2() Dim rng As Range Range("D3:D7") = Application.Substitute(Range("C3:C7"), "e", "") Set rng = Range("D3:D7") [C9] = Application.Average(Range("D3:D7")) [D9] = Application.Average(rng) End Sub But I can't get any of the following lines of code to work in Avv1. The first two lines with rng cause compiler errors whilst the last line [C9] = doesn't give a compiler error but returns #DIV/0! in [C9]. Sub Avv1() Dim rng As Range Set rng = Range(Application.Substitute(Range("D3:D7"), "e", "")) rng = Range(Application.Substitute(Range("D3:D7"), "e", "")) [C9] = Application.Average(Application.Substitute(Range(" C3:C7"), "e","")) End Sub I'm just trying to find the average for the list of numbers and I would like to do this without having to copy them stripped down somewhere else first. TIA Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Problem | Excel Worksheet Functions | |||
calculation problem... | Excel Programming | |||
Calculation problem - please help | Excel Discussion (Misc queries) | |||
Calculation problem | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |