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);
}