Claus Busch wrote:

Hi Terry,

Am Fri, 31 Jan 2020 18:31:33 +0000 schrieb Terry Pinnell:

I'm still struggling to find what I'm doing wrongly with Claus's last
code, but I think I'll put it aside for now and retire to the lounge for
a glass of white ;-)

you get the error when the cipboard is empty.


Regards
Claus B.

Hi Claus & Garry,

I methodically reduced the growing clutter of modules and procedures to
a minimum: just your macro and the 'clipboard overhead'. Then I tried
again. Still same result!

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

The data for clipboard remains the same, but for convenience here it is
again:

20190919MarshGreen-B-r424-m4.4.gpx
Circular walk with Brian, Marsh Green
20190919MarshGreen-B-r424-m4.4
Thursday 19 September 2019
20190919
09:56
11:53
1:56
4.5
2.3
424
242
190
190
Thursday 19 September 2019: Circular walk with Brian, Marsh Green
Start 09:56, End 11:53, Dur'n 1:56 , 4.5 miles, avg. mph 2.3
Gross asc/desc 190 ft, Max 242 ft
C:\Users\terry\Dropbox\FinishedWalks\20190919Marsh Green-B-r424-m4.4.jpg
C:\Users\terry\Dropbox\FinishedWalks\20190919Marsh Green-B-r424-m4.4-PS.jpg
D:\Pictures\PHOTOS\Walks UK\2019\20190919-110750.jpg
30 January 2020

Terry, East Grinstead, UK