Activate a workbook?
Hi Terry,
Am Wed, 08 Mar 2017 13:54:38 +0000 schrieb Terry Pinnell:
If a run that code I get the familiar 'Subscript out of range' error on
this:
Set wshS = ThisWorkbook.Sheets("Track Data")
then change the reference to:
Set wshS = Workbooks("TEST track sheet copying.xlsm").Sheets("Track Data")
Set wshD = ThisWorkbook.Sheets("TEMP")
Regards
Claus B.
--
Windows10
Office 2016
|