Claus Busch wrote:

Hi Terry,

Am Fri, 31 Jan 2020 20:35:27 +0000 schrieb Terry Pinnell:

Here is my latest worksheet:
https://www.dropbox.com/s/p06jmcvnhe...est.xlsm?raw=1

we don't have your data. Our clipboard is empty.
I pasted your data to another sheet and copy it from there.
Have a look:
https://www.dropbox.com/s/5jljxb1jyr...Test.xlsm?dl=0

If you run it on your language version the comma is changed to period
and the day names are in Englisch.


Regards
Claus B.

Hi Claus,

I included the data at the bottom of my 16:45 post and mentioned it at
the top:
"I copy tAll_VBA to the clipboard and use F5 to run your macro. (I've
also pasted a copy of that.)"

BINGO - I just successfully ran your macro! ;-)

I've no idea why yours works and mine didn't. It seems the only
difference in our workflow is that you are copying from a single cell of
a worksheet and I'm copying from my text editor. (I'm pretty sure I also
occasionally copied from a worksheet too, but one line per row.)

I've been up since 5:30 am so I'll get back on the case in the morning.

Many thanks for sticking with me on this!

Best wishes,

Terry, East Grinstead, UK