[VBA] Vlookup sometimes crashing Excel

[thedogg]

Is it possible to replace the vlookup function below by something else? This solution is crashing the excel very often.

Dim rngS As Range
Set rngS = Range("S11:S" & END_Row - 2)    
 
With rngS
 .FormulaR1C1 = "=VLOOKUP(RC[17],'\\ad.igt.com\igt\TEAMS\ TOOL_ADMIN\###IAT Management###\[DS_LOOKUIP_.xlsx]IMDS IDs'!C2:C8,7,0)"
  .Copy
  .PasteSpecial xlPasteValues
   End With
   
Application.CutCopyMode = False

 

[thedogg]

I am still trying to rework the formula on the code but it doesn't work for me at all.