365 Script to copy and add rows then clear contents on a range of cells

[dejan720]

Imagine an Excel 365 list of projects with project names and categorisations in columns 1 to 5
Columns 6 to 20 have financial information.
columns 21 to 30 have fields for project managers to populate.

Now I would like to create a button so that:

Where ever the active cell is it would copy that row, Insert copied cells, then delete or clear contents on the financial information.

I could easily do this in VBA by creating a variable to record what ever row the active cell is on and then build my VBA script around the row of the current active cell.
I can not for the life of me figure out in 365 script.

Please help.

[Torontohrb]

This should be easy. However, your description is confusing. You copy the current row, but where do you want to insert it?