code instead of functions

  • Thread starter Thread starter pls123
  • Start date Start date
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"
 
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 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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill a cell with this.. 4
automatic replacing of vbe code for multiple workbooks 1
How can write this as workbook function ??? 3
Use of Cell Values Instead of Hard Coding 6
How does this code know which sheet to act upon? 5
Retain decimal places in a concatenate function 2
concatenate more column value 3
Bold items within text string 7

Back
Top