SteveM99
10-14-2017, 01:57 PM
I am trying to create a macro that will insert a range starting where the active cell is located. For example a user needs to add a section where they are, they would click on the cell where they want to start and then press a macro button and a range would be inserted. I believed breaking it into two parts would make sense like inserting blank row and then copy pasting the range needed in the section but possibly insert cells can do it directly.
So if I need to insert cells into C10 to E15 from Q100 to S115 (the range I want to copy) what would code be? I need it dynamic meaning the user may be in another area so that the only thing fixed is Q100 to S115 (the range being copied). I don't want the range moved just copied in.
So if I need to insert cells into C10 to E15 from Q100 to S115 (the range I want to copy) what would code be? I need it dynamic meaning the user may be in another area so that the only thing fixed is Q100 to S115 (the range being copied). I don't want the range moved just copied in.