Struggling to get VBA code to hide some rows successfully - almost there I think

Hi, I have a spreadsheet that has a dropdown in cell E13 with 3 choices - A, B, C

I have three named ranges;
Range A rows $3:S5
Range B rows $6:$10
Range C rows $11:$15

If the user chooses A from E13 I would like only Range A rows to show and the others hide, If they choose B only Range B to show and the others hide and if they choose C only Range C to show and the others hide.

Ive been trying this but Im failing as nothing happens (code is definitely incorrect);

Please Login or Register  to view this content.

There may be another way to do this that may be easier so any guidance would be most gratefully appreciated. I may have bitten off more than I can chew...

Thank you.

If you are trying to do this automatically when E13 is changed then the sub name should be

Please Login or Register  to view this content.

Another option, without the need for named ranges

Please Login or Register  to view this content.

But are you trying to hide the rows on a different sheet to the dropdown?

Thank you so much - no the rows are being hidden on the same worksheet...I will give it a try

I will give this a good go - thank you so much for taking the time.

Ok sorry to sound a bit thick - but I need to declare the variable MyArray for it to work?

Originally Posted by Fluff13

Another option, without the need for named ranges

Please Login or Register  to view this content.

But are you trying to hide the rows on a different sheet to the dropdown?

I tried this but get a runtime errortype mismatch on the last line - what does the -64 indicate please? thank you again for your help.

Try

Please Login or Register  to view this content.

This makes it case insensitive.

Originally Posted by mehmetcik

C looks like it is a reserved name. I had to use D.


Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

This works too:

Please Login or Register  to view this content.

OOh Ive got a bit further - I tried the first one here and it worked beautifully for the B and D options but as soon as I click the A option it says method "Range" of object_Worksheet failed
debugger states this line is a problem;
T = Range(Target.Value).Address
This is only displayed if I choose the first option A.
When it does option B and D the cells "flicker"

That worked an absolute treat! I have been working on it for hours and hours and I can use this coding for so many other things - beyond thrilled. Now to work out how to pull data for each of the fields displayed from a table .. thank you so very much - I am genuinely shocked at how strangers are willing to help people like me. thank you again.