VBA Code - Copy & Insert copy to another worksheet.

Hi All,

I'm in a pickle with my super basic coding skills.
I am trying to copy a range of cells from one sheet to another. My code I have created is working for copying my range of data to the last row of my active worksheet. HOWEVER.... I actually want to paste that data at the top of the active worksheet. A simple insert of my copied cells by shifting all other rows down.

Two Sheet names are:
1. Meeting Minutes (this is my active worksheet)
2. Sheet 2 (Template sheet, where I am copying my cell range from).

My Current code is:

Please Login or Register  to view this content.

Can any one help me?

Since "CommandButton" code is found in the sheet module, then you use the "Me." syntax to specify "the sheet in which this code is running."

Please Login or Register  to view this content.

If there is a chance the onscreen sheet is NOT the intended target for some bizarre reason, you cound change Me. to Activesheet.

If that resolves your issue, please select Thread Tools from the menu above and mark the thread as solved. Thanks.