I got a code for search number in a range. I would like to use this one to add a next button (option) to this macro to find the next results as well.
Could it be possible to highlight the entire row where the result found?
Please Login or Register to view this content.
Last edited by ccsmith; 11-18-2012 at 05:50 AM.
Would this help?
Please Login or Register to view this content.
Harry.
Thanks Herry. I don't think about this solution. I don't need to change the color of the row, because i have a many formatting and conditional formats in the cells.
I would like to mark (highlight) the row where the result found. Like i click on the row number. But it will be more important to I can find the NEXT result as well without quitting the macro.
Something like this.
Please Login or Register to view this content.
will this help?Please Login or Register to view this content.
Last edited by vipul.halbe; 11-17-2012 at 01:12 PM.
It's working well. Could it be somehow get information which row nr. contains the results in case of more than 1 hit?
Please Login or Register to view this content.
Thanks HSV. I will use your last solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks