Example #1
0
        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);
        }
Example #2
0
        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);
        }