Thanks very much for this.

I have just changed 'MyStyle' to 'Normal' to test.

I am getting a Compile error: Expected Function or variable @ .PasteandFormat

I have tried to fix this to no avail - can you help me yet again please?