i tried removing :
LookIn:=xlValue, LookAt:=xlWhole,
and tested, it seems to be working but not sure whether it will cause any other issues.

Thanks again for the help.