1*b1cdbd2cSJim JagielskiTest run started : 12/05/2009 11:23:35 2*b1cdbd2cSJim Jagielski---------------------------------------------------------------- 3*b1cdbd2cSJim JagielskiTestAddress 4*b1cdbd2cSJim Jagielski TEST START : TestAddress 5*b1cdbd2cSJim Jagielski ITEM Assertion OK : test1 Range('e3:f3') A1 style addressing 6*b1cdbd2cSJim Jagielski ITEM Assertion OK : test2 Range('e3:f3') R1C1 style addressing 7*b1cdbd2cSJim Jagielski ITEM Assertion OK : test3 Range ('e:f') A1 style addressing 8*b1cdbd2cSJim Jagielski ITEM Assertion OK : test4 Range ('e:f') R1C1 style addressing 9*b1cdbd2cSJim Jagielski ITEM Assertion OK : test5 Columns A1 style addressing 10*b1cdbd2cSJim Jagielski ITEM Assertion OK : test6 Columns R1C1 style addressing 11*b1cdbd2cSJim Jagielski ITEM Assertion OK : test7 Columns(3) A1 style addressing 12*b1cdbd2cSJim Jagielski ITEM Assertion OK : test8 Columns(3) R1C1 style addressing 13*b1cdbd2cSJim Jagielski ITEM Assertion OK : test9 Columns('e') A1 style addressing 14*b1cdbd2cSJim Jagielski ITEM Assertion OK : test10 Columns('e') R1C1 style addressing 15*b1cdbd2cSJim Jagielski ITEM Assertion OK : test11 Columns('b:d') A1 style addressing 16*b1cdbd2cSJim Jagielski ITEM Assertion OK : test12 Columns('b:d') R1C1 style addressing 17*b1cdbd2cSJim Jagielski ITEM Assertion OK : test13 Range('c1:g10').Columns A1 style addressing 18*b1cdbd2cSJim Jagielski ITEM Assertion OK : test14 Range('c1:g10').Columns R1C1 style addressing 19*b1cdbd2cSJim Jagielski ITEM Assertion OK : test15 Range('c1:g10').Columns(1) A1 style addressing 20*b1cdbd2cSJim Jagielski ITEM Assertion OK : test16 Range('c1:g10').Columns(1) R1C1 style addressing 21*b1cdbd2cSJim Jagielski ITEM Assertion OK : test17 Range('c1:g10').Columns('a') A1 style addressing 22*b1cdbd2cSJim Jagielski ITEM Assertion OK : test18 Range('c1:g10').Columns('a') R1C1 style addressing 23*b1cdbd2cSJim Jagielski ITEM Assertion OK : test19 Range('c1:g10').Columns('c') A1 style addressing 24*b1cdbd2cSJim Jagielski ITEM Assertion OK : test20 Range('c1:g10').Columns('c') R1C1 style addressing 25*b1cdbd2cSJim Jagielski ITEM Assertion OK : test21 Range('c1:g10').Columns('x:z') A1 style addressing 26*b1cdbd2cSJim Jagielski ITEM Assertion OK : test22 Range('c1:g10').Columns('x:z') R1C1 style addressing 27*b1cdbd2cSJim Jagielski ITEM Assertion OK : test23 Range('c1:g10').Columns(30) A1 style addressing 28*b1cdbd2cSJim Jagielski ITEM Assertion OK : test24 Range('c1:g10').Columns(30) R1C1 style addressing 29*b1cdbd2cSJim Jagielski ITEM Assertion OK : test25 Worksheets('Sheet2').Cells(1, 1) A1 style addressing 30*b1cdbd2cSJim Jagielski ITEM Assertion OK : test26 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, RowAddressAbsolute is false 31*b1cdbd2cSJim Jagielski ITEM Assertion OK : test27 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, ColAddressAbsolute is false 32*b1cdbd2cSJim Jagielski ITEM Assertion OK : test28 Worksheets('Sheet2').Cells(1, 1) R1C1 style addressing 33*b1cdbd2cSJim Jagielski ITEM Assertion OK : test29 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing 34*b1cdbd2cSJim Jagielski ITEM Assertion OK : test30 Worksheets('Sheet2').Range('A1').EntireColumn A1 style addressing 35*b1cdbd2cSJim Jagielski ITEM Assertion OK : test31 Worksheets('Sheet2').Range('A1:E5').EntireRow A1 style addressing 36*b1cdbd2cSJim Jagielski ITEM Assertion OK : test32 Worksheets('Sheet2').Range('A1') A1 style addressing 37*b1cdbd2cSJim Jagielski ITEM Assertion OK : test33 Worksheets('Sheet2').Range('IV65536').EntireRow A1 style addressing 38*b1cdbd2cSJim Jagielski ITEM Assertion OK : test34 Worksheets('Sheet2').Range('IU2:IV65536') A1 style addressing 39*b1cdbd2cSJim Jagielski ITEM Assertion OK : test35 Range('c1:g10').Columns('x:z') R1C1 style addressing 40*b1cdbd2cSJim Jagielski ITEM Assertion OK : test36 Worksheets('Sheet2').Range('A1') A1 style addressing 41*b1cdbd2cSJim Jagielski ITEM Assertion OK : test37 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing 42*b1cdbd2cSJim Jagielski ITEM Assertion OK : test38 Worksheets('Sheet2').Range('10:12') A1 style addressing 43*b1cdbd2cSJim Jagielski ITEM Assertion OK : test39 Worksheets('Sheet2').Range('10:12') R1C1 style addressing 44*b1cdbd2cSJim Jagielski ITEM Assertion OK : test40 Range('Sheet3!A1:B4') A1 style addressing 45*b1cdbd2cSJim Jagielski ITEM Assertion OK : test41 Range('Sheet3!A1,B1,D4:F20') A1 style addressing 46*b1cdbd2cSJim Jagielski ITEM Assertion OK : test42 Range('g20:h40').Columns('c:c') 47*b1cdbd2cSJim Jagielski ITEM Assertion OK : test43 Range('g20:h40').Columns('c:f') 48*b1cdbd2cSJim Jagielski ITEM Assertion OK : test44 Range('g20:h40').Columns(-1) 49*b1cdbd2cSJim Jagielski ITEM Assertion OK : test45 Range('c4:g10').Rows(-1) 50*b1cdbd2cSJim Jagielski ITEM Assertion OK : test46 Range('a2:b4').Rows('1:1') 51*b1cdbd2cSJim Jagielski ITEM Assertion OK : test47 Range('a2:b4').Rows('1:2') 52*b1cdbd2cSJim Jagielski ITEM Assertion OK : test48 Range('a2:b4').Rows('2:2') 53*b1cdbd2cSJim Jagielski ITEM Assertion OK : test49 Range('a2:b4').Rows('2:3') 54*b1cdbd2cSJim Jagielski ITEM Assertion OK : test50 Range(' A2:B4 ') 55*b1cdbd2cSJim Jagielski ITEM Assertion OK : test51 Range('A 2:B 4') 56*b1cdbd2cSJim Jagielski ITEM Assertion OK : test52 Range('A2 : B4 ') 57*b1cdbd2cSJim Jagielski ITEM Assertion OK : test53 Range('Sheet1 !A2 : B4 ') 58*b1cdbd2cSJim Jagielski ITEM Assertion OK : test54 Range('Sheet1! A2 : B4 ') 59*b1cdbd2cSJim JagielskiTest Results 60*b1cdbd2cSJim Jagielski============ 61*b1cdbd2cSJim Jagielski 62*b1cdbd2cSJim JagielskiTests passed: 54 63*b1cdbd2cSJim JagielskiTests failed: 0 64*b1cdbd2cSJim Jagielski 65*b1cdbd2cSJim JagielskiEND 'TestAddress 66*b1cdbd2cSJim Jagielski TEST OK : TestAddress 67*b1cdbd2cSJim JagielskiTest run finished : 12/05/2009 11:23:35 68