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.
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
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).
This is VERY useful. I've just found additional results in a large database that had previously been missed by swapping to the search function.
Thanks for the video, Very Nice!
QQ: Which Formula would work when you are searching for GE in GE but not GE in MGEX?
A great explanation. Thank you for telling us the examples with wildcards!
Great advice! Easy to make a mistake if not well understood between the two functions. Thanks for the lesson. Thumbs up!!
Thanks! I couldn't agree more! Honestly, if you don't use both of them for a few weeks, I find it too easy to forget which is which.
Very helpful, thanks
Well explained...
What I want to find the position of space before the word "Value" ....
Well explained thank you for your hard work
You're welcome! I'm glad you liked it! I'm thinking I might do more like this one.
Great Tutorial Really Well Explained..Thank You Sir :)
Thanks! I'm glad you liked it! I'm thinking of maybe doing more in this style of comparing functions.
Thank u so much sir
Really well explained. Thank you.
You are very welome! I'm glad you think so :)
I need to search starting from right to left... is this even possible?
Thanks sir
Hello there...is it possible to run a macro just after power query refresh automaticaly ...Data Refresh then Macro Run ...
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.
BTW: if you need to search for a ~, you must use ~~ in your find_text string. It happened to me…
What to do if there is multiple same data in same column, how to get both data Position number
I HAVE A HUGE LIST OF NUMBERS AND I NEED TO FIND 191 FROM THE LONG LIST PLEASE HELP
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 have watched this twice , still have no idea what your talking about
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).
You talk too much nonsense. The 3 minute video was 11 minutes. An expert is someone who describes an event simply and in a short time.