Enhance existing code to hide rows between specific text

Hi All

I need help with my existing code. I have a workbook which contains 8 worksheets. I want to able to run a macro that looks for specific words in column A of each worksheet and hides any rows in between the specified words. The following code works except if a worksheet does not contain the specified words. Is there a better way to accomplish this?

Attached is an example of the spreadsheet. The code below works just fine on the tabs highlighted in green, but halts on the tab highlighted in red. The tab highlighted in yellow is showing you the rows I need to hide.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hi John - Thanks for the reply... the code you provided works except on the one worksheet that doesn't have EBITDA %. That one ends up having all rows hidden except the EBITDA TTM row. See attached.

Try:

Please Login or Register  to view this content.

Thank you John... that works.

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.