01 0 +0+0)0+#ofset1.wkLL     & ABC123cZ ADDR1D6Z   COLS_ROWS"" COLS_ROWS@)) C_RANGE0F3** DONAME1D6   HOMEE1D6 MAC7X1D6 NAME1D66   RANGE0F3)) RANGE7X1 RANGE@1   R_RANGE0F3++ STX7X10F3 TEST10F3 TESTCOLS3 TESTROWS3   WCOLOWS3 WCOLSWS3 WITH@WS3 WROWWS3 WROWSWS3 \XWSWS3 EG9WS3<>A:H35..A:H50 EG:WS3<>A:I35..A:I50 EG;WS3<>A:J35..A:J50 EG<WS3<>A:K35..A:K50 EG=WS3<>A:L35..A:L50 EG>WS3<>A:M35..A:M50 EG?WS3<>A:G35..A:G50 CG@WS3<>A:B1..A:B1 CGAWS3<>A:G1..A:G1 CGBWS3<>A:H1..A:H1 CGCWS3<>A:I1..A:I1 CGDWS3<>A:J1..A:J1 CGEWS3<>A:L1..A:L1 CGFWS3<>A:H2..A:H2 CGGWS3<>A:I2..A:I2 CGHWS3<>A:J2..A:J2 CGIWS3<>A:K2..A:K2 CGJWS3<>A:L2..A:L2 CGKWS3<>A:M2..A:M2 EGVWS3<>A:G35..A:M50 ;GWWS3<>A:IL1..A:IQ1 CGXWS3<>A:H2..A:M2 >Q2WS3<>ACC_PAYABLE CXSWS3<>A:A4..A:A4 <G9WS3<>A:IL2..A:IL20 <G:WS3<>A:IM2..A:IM20 <G;WS3<>A:IN2..A:IN20 <G<WS3<>A:IO2..A:IO20 <G=WS3<>A:IP2..A:IP20 <G>WS3<>A:IQ2..A:IQ20 <G?WS3<>A:IK2..A:IK20 ;GFWS3<>A:IL1..A:IL1 ;GGWS3<>A:IM1..A:IM1 ;GHWS3<>A:IN1..A:IN1 ;GIWS3<>A:IO1..A:IO1 ;GJWS3<>A:IP1..A:IP1 ;GKWS3<>A:IQ1..A:IQ1 <GVWS3<>A:IK1..A:IQ20 AGWWS3<>A:IK8190..A:IK8190 CXSWS3<>A:D8187..A:D8187 @G9WS3<>A:D3..A:D8188 CGFWS3<>A:B1..A:B1 CGGWS3<>A:C1..A:C1 CGHWS3<>A:D1..A:D1 CGIWS3<>A:E1..A:E1 CGJWS3<>A:F1..A:F1 CGKWS3<>A:G1..A:G1 CXSWS3<>A:C8187..A:C8187 EG9WS3<>A:C35..A:C50 EG:WS3<>A:D35..A:D50 EG;WS3<>A:E35..A:E50 EG<WS3<>A:F35..A:F50 EG=WS3<>A:G35..A:G50 EG>WS3<>A:H35..A:H50 EG?WS3<>A:B35..A:B50 EGVWS3<>A:B35..A:M50 EG9WS3<>A:B35..A:B50 EG:WS3<>A:C35..A:C50 EG;WS3<>A:D35..A:D50 EG<WS3<>A:E35..A:E50 EG=WS3<>A:F35..A:F50 EG>WS3<>A:G35..A:G50 EG?WS3<>A:A35..A:A50 CGFWS3<>A:B1..A:B1 CGGWS3<>A:C1..A:C1 CGHWS3<>A:D1..A:D1 CGIWS3<>A:E1..A:E1 CGJWS3<>A:F1..A:F1 CGKWS3<>A:G1..A:G1 EGVWS3<>A:B35..A:M50 EG9WS3<>A:H35..A:H50 EG:WS3<>A:I35..A:I50 EG;WS3<>A:J35..A:J50 EG<WS3<>A:K35..A:K50 EG=WS3<>A:L35..A:L50 EG>WS3<>A:M35..A:M50 EG?WS3<>A:A35..A:A50 CGFWS3<>A:H2..A:H2 CGGWS3<>A:I2..A:I2 CGHWS3<>A:J2..A:J2 CGIWS3<>A:K2..A:K2 CGJWS3<>A:L2..A:L2 CGKWS3<>A:M2..A:M2 CGVWS3<>A:A9..A:A9 CBCOPY3 DDF0PY3<>A:N4..A:N42 *DQ0PY3<>Y1991_92 =DQ1PY3<>SALARIES 5DS0PY3<>CURRENCY CDSKPY3<>A:D8187..A:D8187 EGC0PY3<>A:L35..A:L50 RN0PY3ABC123!  ?? @VLBLBs+q+q+@ DATE PRICE UNIT PRICE TRENDGRAPH1q+q+q+UNIT TRUSTSq+q+q+ Arial MT Arial MT Arial MT! Arial" Arial# Arial' Arial MT( Arial MTW+ + +$'+%(+"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefinedq0*1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#1*FF 3*#(4*"########"""!"###h5*q0*1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#1*FF 3*#(4*"########"""!"###h5*q0*1* 3*#(4*"########"""!"###h5*@@@@@@@@@@@@@@ @@@@@ @  @ @ @ @ @@ @ @ @ @ @ @ @ @   @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@((((((((( ( ( ( ( ((((((((((((((((((( !@@@"@@# $#%$&@@'(@@@@)*+*,'-.-/.0/ (!("(#($(%(&('((()(*(+(,(-(.(/(0( ~'F'LAPSOFT MACRO LIBRARY Release 1 July 1999 http://www.lapsoft.com^'place cursor at macro command to execute and press crtl X will execute only that command'\X0'{LET <>ABC123,@CELLPOINTER("CONTENTS")} 'ABC123 '{COLS_ROWS a1..c4,E30,F30}'{RANGE@ +"HOME",+"A1"}'{RANGE@ NAME,ADDRESS}8'range name create with name RANGE_NAME and ADDRESS 'ADDR1D6 'A1 'RANGE@, '{DEFINE <>NAME1D6:V,<>ADDR1D6:V} 'NAME1D6 'HOMEx '{IF #NOT#@ISERR(@FIND(">>",<>NAME1D6,0))}{LET <>NAME1D6,@MID(<>NAME1D6,@FIND(">>",<>NAME1D6,0)+2,512)}x '{IF #NOT#@ISERR(@FIND(">>",<>ADDR1D6,0))}{LET <>ADDR1D6,@MID(<>ADDR1D6,@FIND(">>",<>ADDR1D6,0)+2,512)}D '{LET <>DONAME1D6,+"/RNC"&<>NAME1D6&"~"&<>ADDR1D6&"~"} 'DONAME1D6 '/RNCHOME~A1~ 'TEST!'{WITH@ +"TEST",+"{RETURN}"}'{WITH@ RANGE,MACRO}P'Scans through RANGE incrementing COL and ROW (from 0) and executing MACRO.'RANGE7X1 'TEST 'WITH@,'{DEFINE <>RANGE7X1:V,<>MAC7X1:V} 'WCOLA'{<>COLS_ROWS@ <>RANGE7X1,+"<>WCOLS",+"<>WROWS"} 'WROW2'{FOR <>WCOL,0,<>WCOLS-1,1,<>STX7X1} 'STX7X12'{FOR <>WROW,0,<>WROWS-1,1,<>MAC7X1} 'WCOLS 'MAC7X1'{RETURN} 'WROWS'TESTCOLS '{COLS_ROWS a1..c4,E30,F30} 'TESTROWS / '{COLS_ROWS range,output_cols,output_rows}O!'Calc col & row count of 'range' output to 'output_cols' and 'output_rows'"'COLS_ROWS<"'{DEFINE <>RANGE0F3,<>C_RANGE0F3,<>R_RANGE0F3}E#'{<>COLS_ROWS@ <>RANGE0F3,<>C_RANGE0F3,<>R_RANGE0F3}6&'{COLS_ROWS@ range:V,output_cols:V,output_rows:V}*''{COLS_ROWS@ +"USA1",+"B198",+"B199"}j('Calc col & row count of 'range' indirect output to 'output_cols' indirect and 'output_rows' indirect)'RANGE0F3 )'a1..c4)'COLS_ROWS@B)'{DEFINE <>RANGE0F3:V,<>C_RANGE0F3:V,<>R_RANGE0F3:V}*'C_RANGE0F3 *'E305*'{LET +<>R_RANGE0F3,@ROWS(@@(<>RANGE0F3))}+'R_RANGE0F3 +'F305+'{LET +<>C_RANGE0F3,@COLS(@@(<>RANGE0F3))}-W_  Arial MT Arial MT Arial MT Arial MTTimesNewRomanPSTimesNewRomanPSTimesNewRomanPSArial      O-N &<@|#W  Bodo    Doc Info AuthorDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info Last RevisorDoc Info ObjectDoc Info PropertyDoc Info Revisions CountFM3FM3 PropertyWK3WK3 Property  9( 69 968 8  8 8 8 ,8 :8B888 H8 8 X8 8 o88CMHdr9(