Hide or show multiple named ranges of rows

Dear all,
I'm newbie with VBA, so I'm sure that the code below can be improved to do what I describe below, but I can't find. I'm sure you experts can help

My workbook contains 3 tabs.
First tab serves to select criteria. Depending on the criteria selected by the user, there are three possible cases (A,B,C)
depending on the cases, rows in each sheet are hidden or shown and some rows show a predefined text.

What I want to do is the following:

• Is it possible to name the ranges (for example to call rows 1 to 40 "experience", 41 to 44 "training" and so on) and to indicate the rows range name instead of the row numbers? otherwise I have to modify multiple lines whenever I insert new rows in the Sheets.

• Moreover, after a case is selected, I would want that, depending on the answer to a question, some rows can also be hidden or shown.
  For example, case A shows rows 45 to 120 in sheet "MySheet1". If the user answers "Yes" to a question in cell B50 of "MySheet1, rows 51 to 65 are also hidden.

Thanks for any help!

Please Login or Register  to view this content.

A while ago I did something smilar for someone else so if you post an example workbook with some named ranges I'm sure we can get it working.

Did it for case A so you can see how it works. You can expand it yourself later on.