OFFSET macro specific col reference

[LadyReader]

I want to write a macro which will enable the user, who has selected any row, to insert a new row above the selected row, and copy the data in columns A and B from the row above the inserted row.

I have:

Please Login or Register  to view this content.

This copies the entire previous row. How do I copy only columns A and B, for example? I am sure there is an utterly simple answer but I keep getting syntax or runtime errors with whatever I try.

Thank you.

[StephenR]

Perhaps like so, which will insert a row above whichever cell is active:

Please Login or Register  to view this content.