Activate a workbook?
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.
--
Windows10
Office 2016
|