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