I often have to conduct a search for a given string, whether in the value of cells or inside the formulas (and searching backwards, from the end of the document to its beginning).
Presently I cannot but run the search twice: first searching in the values and then in the formulas.
The first with this code (essentially):
Which I do by clicking on a CommandButton in a UserForm I have created, once for each occurrence, until I find the one I am looking for.
The second with this code (essentially):
by clicking on another CommandButton in my UserForm, once for each occurrence.
But that double search is awkward and time consuming, for sometimes I must peruse the whole document the first time (through values) and then again (through formulas) part of it or the whole also.
I wonder if there is a way of searching through both (values and formulas) in one run. That would imply something like this in the code line of my macro:
I know that syntax is not allowed; but is there some other code to that same effect?
Thank you for any help.
Bookmarks