Find & Replace Text for Hidden Tabs

[mflatt23]

I've got an investing checklist workbook with over 150 companies, each on a separate worksheet. Within each worksheet, there is a question "Is the FCF Yield ≥ 4%?" I'd like to update this text to instead say something different ("Is the FCF Yield ≥ its 10-year median?"). However, from what I'm seeing, I can only make this update using find & replace on unhidden worksheets. I think my computer would significantly slow down or crash if I had to unhide 150+ worksheets to update this question. Is there another way to accomplish this task? Perhaps using VBA Code?

Here is a link to a visual of my spreadsheet (cell B35):

Screenshot-1 hosted at ImgBB

Image Screenshot-1 hosted in ImgBB

ibb.co

Thanks for any help!

 

[mflatt23]

Perfect! Thank you

 

[igold]

Happy to help, thanks for the feedback!