| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| Using Functions in VBA code | Excel Programming | |||
| AddIn functions in code? | Excel Programming | |||
| not sure what functions/code to use? | Excel Programming | |||
| How to see code for general functions? | Excel Programming | |||
Linear Mode
