如何使用VBA在Excel中的单个列（A）中搜索字符串

I want to change these lines in my excel VBA code to something much faster, instead of looping through all the rows, i did saw examples but could not understand them as i am not a VBA user.I want to change these lines in my excel VBA co