Thanks. Getting there. The code does what it says on the tin
Just a couple of questions:
1. Not all columns in the worksheet. Column A is one of these. Hence the original ask.
2. Is it possible to limit the change event to the last empty cell in column A? (I have found that any further change to already entered entries in column A results in another row being added when it is not necessary.