code instead of functions
 

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"

code instead of functions
 

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"

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"

code instead of functions
 

You are welcome! Thanks for the feedback!
Stefi

€žStefi€� ezt Ã*rta:

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"