Excel Macro inserts row but does not insert next number in row.

G'Day everyone,

I am trying to put a macro in a spreadsheet that will prompt the user to click the button and for the macro to insert a new row and add to the number above.

i.e. insert a new row and number it numerically.


So far...

Sub Button7_Click()

Rows("27:27").Select
Selection.Insert Shift:=x1Down

End Sub

Thanks a million for any help.

Cheers.