Extending Range in Code

That worked perfectly! Thanks for you help BellyGas.

If possible I have one more question. If I wanted to offset the output from changes in column A to start printing them at the end of the spreadsheet (say from column Z onwards), is this possible?

Thanks