Hello everyone! I'm trying to copy the value from a formula and paste the result as a value only, but when the code is run I receive a #DIV/0! error. The code I have is:
Range("S4").Activate
Selection.Formula = "=average(O15:O500)"
Range("S5").Select
ActiveCell.FormulaR1C1 =...