FreeIndeed
01-07-2016, 11:40 AM
Hi there.
I am trying to set up a search function for my Workbook so that I can search data from every page in the workbook and then display the results on the original page (under the search bar.) I am working from an example and it works fine if all my data is on the page with the search feature. But, I can't figure out how to change the code so that it will search every page. I think the answer is in the code where it loads the sheet into a variable : Set sht = ActiveSheet
Can anyone help with what I would need to change to get it to load/search ALL sheets?
Thanks in advance!
15121
I am trying to set up a search function for my Workbook so that I can search data from every page in the workbook and then display the results on the original page (under the search bar.) I am working from an example and it works fine if all my data is on the page with the search feature. But, I can't figure out how to change the code so that it will search every page. I think the answer is in the code where it loads the sheet into a variable : Set sht = ActiveSheet
Can anyone help with what I would need to change to get it to load/search ALL sheets?
Thanks in advance!
15121