Claus Busch wrote:
Hi Terry,
Am Sat, 04 Mar 2017 19:17:52 +0000 schrieb Terry Pinnell:
Workbooks("TEST track sheet copying.xlsm").Activate
Sheets("TEMP").Range(“A1”).Select
But that failed.
try:
Application.Goto Workbooks("TEST track sheet copying.xlsm").Sheets("TEMP").Range("A1")
Regards
Claus B.
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
Terry, East Grinstead, UK