Greetings.
I am having trouble being able to copy the last two columns with data in a worksheet and then insert the same columns to the right of them. Here is my code so far, it does not work because the top row is merge of more columns. Here is the
is the screenshot link.
I am having trouble being able to copy the last two columns with data in a worksheet and then insert the same columns to the right of them. Here is my code so far, it does not work because the top row is merge of more columns. Here is the
Code:
Sub newTest()
Columns("I:J").Select
Range("I:J").Select
Selection.Copy
Selection.Insert Shift:=xlToRight
End Sub