chapter40

USING THE ACTIVECELLDEMO MACRO5 - 511 - =A2+3*2USING THE ACTIVECELLDEMO1 MACROMEANRETURN IN ACTION100.000 0.160 - =meanreturn(A2:A7)110.000 0.100 - =meanreturn(A2:A4)121.000 0.200 - =meanreturn(A4:A7)145.200174.240209.088A B C1234567 RangeDemo() RangeDemo2()RangeDemo1() RangeDemo3()A B C D12345678 RangeDemo4()E F12345678 WithoutDemo()WithDemo()A B C D E12345678910111213141516This is The One CR CRCR CR CRCR CR CRCR CR CRCR CR CRF G H12345678910111213141516FOREACHSUM DEMO1 4 7 6 - =ForEachSum(A2:A4)2 5 8 12 - =ForEachSum(A2:C2)3 6 9 45 - =ForEachSum(A2:C4)A B C D E1234ZERORANGE IN ACTION ZeroRange()FillAndPosition()0 0 00 0 00 0 0 ZeroRange()FillAndPosition()A B C D12345 LISTOPENWORKBOOKS IN ACTIONListOpenWorkbooks()List of open WorkbooksCreated on:Saturday, September 08, 2007 At: 4:23:02 PMC:simonWORKFM3Disk with bookChapter filesfm3_chapter 40.xlsC:simonWORKFM3Disk with bookChapter filesfm3_chapter38.xlsC:simonWORKFM3Disk with bookChapter filesfm3_chapter07.xlsA B C D12345678910 AddWorkBook()A B123NAMECURRENTREGION IN ACTION1 2 36 5 47 8 9ISNAME IN ACTIONName IsNameBen TRUE - =IsName(A3)Simon FALSE - =IsName(A4)ben FALSE - =IsName(A5)A B C12345NAMEDMEANRETURN IN ACTIONAsset1 Asset2100 100 0.1 - =meanreturn(A3:A7)110 120 0.2 - =meanreturn(B3:B7)121 144 0.1 - =NamedMeanReturn(Asset1)133.1 172.8 0.2 - =NamedMeanReturn(Asset2)146.41 207.36 0.2 - =NamedMeanReturn(aSsEt2)A B C D1234567IsNameV In ActionName IsNameBen TRUESimon FALSEben FALSEA B C D12345