Method of selecting an area with a macro

[WildGlio]

I have designed a form which at one point needs to be able to have additional
formatted rows inserted. I have created a reference row and can select it by
Ctrl G etc, but I actually want to select the row two rows above this
reference row which will change every time I add a row. I then copy this row
and select Insert Copied Cells.
This must be possible? Please!!

 

[Duke Carey]

give your reference row a range name, eg "RefRow"

in your code,

Range("RefRow").Copy
Range("RefRow").Offset(-2, 0).Insert Shift:=xlDown