Can't add DropLists automatically to new row in Table

[Ochimus]

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

[Akuini]

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

Please Login or Register  to view this content.

[Ochimus]

Akuini,

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

Ochimus

[Akuini]

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