* see Pg 94 in MS Office Automation for merging; will use the method getting a reference to the first * cell, then the 3rd cell and then invoking .Merge() passing the second cell to merge with STORE loRow.Cells(1) TO loCell_1 STORE loRow.Cells(3) TO loCell_3 * merge the cells loCell_1.Merge(loCell_3)but could not get the "2nd method" to work i.e. I did not know how to create an object reference to a range of cells (e.g. cells 1 to 3 above). This was the code that was in the book but it did not explain how to get "oCells"
oCells.Merge()Thanks,