text: public static CellRangeAddress CreateEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB){if (crB == null){return crA.Copy();}return new CellRangeAddress(lt(crB.FirstRow, crA.FirstRow) ? crB.FirstRow : crA.FirstRow,gt(crB.LastRow, crA.LastRow) ? crB.LastRow : crA.LastRow,lt(crB.FirstColumn, crA.FirstColumn) ? crB.FirstColumn : crA.FirstColumn,gt(crB.LastColumn, crA.LastColumn) ? crB.LastColumn : crA.LastColumn);}