Hi Terry,
Am Sun, 05 Mar 2017 08:07:48 +0000 schrieb Terry Pinnell:
Now tested. Still gives me that subscript error, Claus. Here's my layout
in case you see any clues.
https://dl.dropboxusercontent.com/u/...Copying-05.jpg
in workbook "TEST track sheet copying.xlsm" is only one sheet and that
is named "Track Data"). Change the line to:
Application.Goto Workbooks("TEST track sheet copying.xlsm").Sheets("Track Data").Range("A1")
Regards
Claus B.
--
Windows10
Office 2016