How do I hide column/rows in all named ranges whose name starts with specific string, with VBA?

I would like to hide/show columns/rows that are contained in the named ranges whose name starts with a specific string. (e.g. "EU5_").

The goal is to have a specific naming convention for all the worksheets in order to be able to show or hide the rows/columns based on the selected region.

Thank you!

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum