code instead of functions

's Computer Specifications

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 Computer Specifications

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"

's Computer Specifications

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"

's Computer Specifications

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"

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert cell formula functions to code functions	Adnan	Microsoft Excel Misc	1	1st Oct 2008 08:30 PM
Code Behind and functions	Gary	Microsoft ASP .NET	8	26th Jan 2007 01:11 PM
Using Functions in VBA code	=?Utf-8?B?Q2hyaXMgR29yaGFt?=	Microsoft Excel Programming	2	15th Nov 2005 12:05 PM
not sure what functions/code to use?	s&d	Microsoft Excel Programming	6	8th Jul 2005 01:28 AM
How to call code in aspx webform from functions defined in code behind modules	CW	Microsoft ASP .NET	3	2nd May 2004 03:20 PM