Can't add DropLists automatically to new row in Table

If I select the next free row in Cols C & D (Row 5 in this example), Macro should 'copy and paste' the DropLists from the row above, then clear the contents, as shown in Cols L and M.

Attached Code doesn't do it, but can't see why?

Please Login or Register  to view this content.

All solutions, suggestions or alternatives welcome as ever

Ochimus

Try this:
Put the the code in the sheets STOCK code module.

Please Login or Register  to view this content.

Akuini,

Many thanks for prompt solution, and can now mark this as "Solved".

Ochimus

You're welcome, glad to help, & thanks for the feedback.