How to write STDev formula in a macro

Posted to microsoft.public.excel.programming

Chua

external usenet poster

Posts: 8

How to write STDev formula in a macro

I have a list of data over 600 points to calculate the STDev.

Eg. Range A1:IR252 and Range A9:IR252

Anyone has idea how to write a macro to detect the different rows of values
and calculate the STDev using VBA?

Thanks

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
Use macro to write formula	nc	Excel Discussion (Misc queries)	1	July 5th 09 07:13 AM
Conditional STDEV formula	Phil Trumpy	Excel Programming	4	May 24th 07 02:00 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?	Daniel	Excel Worksheet Functions	1	June 23rd 05 11:38 PM
Auto Sum formula - how to write in Macro	s_u_resh[_5_]	Excel Programming	1	October 25th 04 06:06 PM
Auto Sum formula - how to write in Macro	s_u_resh[_3_]	Excel Programming	1	October 25th 04 04:44 PM

All times are GMT +1. The time now is 12:35 PM.

Menu

About Us