code instead of functions
hi stefi tyvm for your help
"Stefi" wrote:
aWS.Range("R2").Value = WorksheetFunction.Sum(Range("L82:L87"))
aWS.Range("S2").Value = WorksheetFunction.Count(Range("L82:L87"))
aWS.Range("T2").Value = Range("R2").Value / Range("S2").Value
Regards,
Stefi
€˛pls123€¯ ezt Ć*rta:
hi all !!
can anyone suggest how can i write this for being executed as code ?? and
not applying in cells the function?? ty everybody
aWS.Range("R2").Value = "=SUM(L82:L87)"
aWS.Range("S2").Value = "=COUNT(L82:L87)"
aWS.Range("T2").Value = "=R2/S2"
|