Macro script to select a row
I am trying to create a macro and am not finding the macro language that I would need to insert a line. This language will be inside a loop that I have already created.
I have a set of data with 6 columns, and am at cell B2. In the macro, I want to move down two rows, select the entire row, then insert a blank row above the selected row. Here is what I currently have, but is it not working. Not sure if it is moving down two rows, and not sure if it is selecting the row.
Rows(2).Select
Selection.Insert Shift:=xlDown
If someone can send the proper instructions to get this part of the macro to work, it would be much appreciated.
|