Posted to microsoft.public.excel.programming

pls123

external usenet poster

Posts: 121

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"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert cell formula functions to code functions	Adnan	Excel Discussion (Misc queries)	1	October 1st 08 08:30 PM
Using Functions in VBA code	Chris Gorham	Excel Programming	2	November 15th 05 12:05 PM
AddIn functions in code?	Rbp9ad[_2_]	Excel Programming	3	October 14th 05 02:54 PM
not sure what functions/code to use?	s&d	Excel Programming	6	July 8th 05 01:28 AM
How to see code for general functions?	eios	Excel Programming	2	November 2nd 04 09:12 AM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us