public static Range Resize(this Range range, int rowHeight = 1, int colWidth = 1) { var msg1 = range.A1_A1(); var newRange = range.get_Resize(rowHeight, colWidth); var msg2 = range.A1_A1(); return(newRange); }
public static Range DisplaceAndResize(this Range range, int displaceRows, int displaceColumns = 0, int rowHeight = 1, int colWidth = 1) { var msg1 = range.A1_A1(); if (range.Row + displaceRows < 1) { System.Diagnostics.Debugger.Break(); } var newRange = range.get_Offset(displaceRows, displaceColumns).get_Resize(rowHeight, colWidth); var msg2 = range.A1_A1(); return(newRange); }