How can I use Excel automation to replace cable types in a macro?

Hi everyone. As with this macro, I have already used Excel automation to automatically replace terminal and connector part numbers, but I am unable to successfully replace the cable part numbers. Has anyone else encountered this issue? Could you please tell me how I should set up the variables for the cables?