vba runtime error 9 subscript out of range error

Trying to update the design table from an external excel worksheet and receive vba run-time error 9 subscript out of range. The error occurs when the program  tries to activate the inbedded solidworks worksheet.  We have a couple of workstations where the program works, but fails on most. The code is attached below, with the problem code in bold.

Thanks

SolidworksConfigurations design Tables