I am trying to utilize the Range.Insert method to insert new rows below my table in Range("G17:K17") in the "Output Sheet" worksheet of my attached file. The code in InsertRows function in Module1 is as follows.
However, executing the above code affects row 22 in Output Sheet and it is no longer of contiguous color. Is it possible to shift cells down in the above range while keeping row 22 intact?