Hello,
I have a noob question pls:
I want to define a variable range and use it to calculate averages. Here is what I have:
Dim rng1 as range
Range("D2").Select
Set rng1 = Range(Selection, Selection.End(xlDown)).Select
ActiveCell.FormulaR1C1 = "=AVERAGE(rng1)"
But it doesn't work and keeps erroring out at average. Any ideas?
Thanks,
Bookmarks