code instead of functions

P

pls123

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"
 
S

Stefi

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:
 
P

pls123

hi stefi tyvm for your help

Stefi said:
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:
Click to expand...
 
Top