Button (or Macro) to insert a row

Hi,

I'm sure this query has been posted many times so apologies for any repeats. I'm new to creating Macros in Excel. I want to create a simple button that will insert a row in between two rows. For instance, if the table contained the following....

Row A Name Surname Location
Row B John Smith England
Row C Joe Bloggs USA

etc...

... i'm hoping to press a button that would insert a row between Row A and Row B allowing me to make another entry under the headings in Row A. Any is help is appreciated.

Thanks.

Place a form button in your spreadsheet. Open a new code module and paste in this code:

Please Login or Register  to view this content.

Right click your button in the spreadsheet, and then click assign macro. Assign the macro InsertRow.