Find All and highlight selected rows
Good day...
Please make some adjustment to existing code or
new vba code in order to get the best results below:
1. Search only from B15:U99999
2. Results highlighted only from:B15 to:U99999 not entire rows (ex: B15:U15; B20:U20)
3. If I need to search new again it will removed the previous highlighted rows and
highlight only for the current search.
4. if C5 = empty then clear all highlighted rows from B15:U99999
Thanks...
See attached file FYI.
Here is how I would attack this with VBA
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks sir, can you make the highlight of the selected cells by rows starting from column B to U instead of selected cells only.
Just like highlighting the entire rows but only from column B to U.
I tried to clear C5 and it didn't clear all highlighted cells...
If I am understanding you correctly, then
Please Login or Register to view this content.
Thank you so much sir, works great...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Can you add some code it here sir as an option on my needs.
Show only the highlighted rows just like the filtered results.
Why are we doing this piecemeal?Please Login or Register to view this content.
Can you add function if i clear C5 it will return all data(unfiltered).
I believe if you clear the data in C5 that you will see that it does exactly what you are asking? Did you even bother to test it for this? You asked for this in Post #3
When I delete the data in C5 and run the VBA, it unhighlights all cells and removes all filtering.Please Login or Register to view this content.
Sorry sir, it's my fault coz I made a second button and still connected to post#4 instead of post#8.
it's working now, thank you so much for your help...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks