Copy and Paste after delete - to maintain total number of rows

A simple problem but my VBA skills are limited.
I have a USERFORM that adds rows to a list of data in a WORRKSHEET called ANALYSISDB. Data is added into columns A to O. I have a code to delete an entry, this deletes the entire row. BUT I have formulas in columns P to AI that refer to the data in columns A to O.

The Workbook is too big to attach to this thread but I've enclose a picture of the Woorksheet

I wish to maintain the overall number of rows to 301 rows (1 row of headers) and copy the formulas in column P to AI into the deleted rows at the bottom of the list. I suspect I can add code to the DELETE action that will perform a copy and paste. Not using VBA I would select the last row of data in Column P to AI and drag the contents down to Rows 301.
The Code I'm using for the DELETE actions is enclosed below
a picture of th

Please Login or Register  to view this content.

Instead of deleting the entire row...

Please Login or Register  to view this content.

A very logical solution to the problem, why didn't I think of that... what does the ".Resize" action actually mean. I'm low on VBA coding skills, but getting up the learning curve
Simon

It allows you to change the size of a range, in this case from 1 column to 15 columns.

https://docs.microsoft.com/en-us/off...l.range.resize