MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_tep4wSgygVE 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
I'm not sure, I'd check out this link stackoverflow.com/questions/14667035/vba-for-excel-afterrefresh-event and if that doesn't help, ask on our forum on TeachExcel.com and provide as much info. as you can or a sample file.
Sometimes it happens, specially if you miss the context. Use the search() under this circumstances: when searching for exact match or for pattern or partial lookup of a given character/string/text and as result, you should get the numeric starting position of that string being searched within the cell content. The search () takes three arguments, the string being searched or to be found, the address or map where to be found (cell, sheet, entire workbook), and the starting position to search from).