Insert blank row at end of table, including formula's

[SDowse]

Hi,

I am wanting to add a blank row at the end of my spreadsheet with only the formula's from the row above.

Idea being, user clicks a button, new row is added with the formula's from the row above...i.e. none of the manually entered information. Some cells are manually populated by the user, others are calculated.

My table is currently across columns A to W, but I am thinking it may get wider at some point so it would be good if the macro can cover from A to last column?

Any ideas?