Terry Pinnell wrote:

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\20190919Mars hGreen-B-r424-m4.4.jpg
C:\Users\terry\Dropbox\FinishedWalks\20190919Mars hGreen-B-r424-m4.4-PS.jpg
D:\Pictures\PHOTOS\Walks UK\2019\20190919-110750.jpg
30 January 2020

Terry, East Grinstead, UK

And both the MsgBox at the start of the macro, AND the clipboard itself
when the macro had finished, still contained the original data.

Terry