VBA查找最后一次出现的字符串

I've been trying to work this problem out for a few days now and I just can't get my head around it. I have searched multiple websites (Even here several times), I have seen that many people have asked this question but the solutions don't work for me.I've been trying to work this problem out for a