[SOLVED]Hide Rows and Columns Based on User Input

**thesteve** · 01-29-2013, 11:30 AM

Hi all,

I'm running into an issue in trying to hide rows based on the input in one cell and hide columns based on the input in the other. Thus far I have only managed to make hiding the rows work as I intended. The code for that is below. How can I also hide columns K:S if "G15" = 1, L:S if "G15" = 2, ... S:S if "G15" = 9? Sorry if this wasn't the most clear.

Please Login or Register  to view this content.

**kcarley** · 01-29-2013, 08:28 PM

Hi there! I would say that you could easily add a new Select...Case block but that would also need some tweaks to the If...Then logic and simply too many lines of code for my taste. I think this may be easy enough to follow but what's more, it simply works the way you've asked. Oh, by-the-way, this works on the sheet that is active so it can be moved from sheet to sheet or added to a module by itself and called on when needed.

Please Login or Register  to view this content.

Cheers!

**thesteve** · 01-31-2013, 11:52 AM

Thanks so much, this works perfectly as I was beginning to get worried I wouldnt ever get it done!

I really appreciate it.

**kcarley** · 01-31-2013, 01:32 PM

Very HAPPY to help.

I have to ask a favor, I'd do it for you but I can't; don't forget to change the title in your original post. Just click Pencil (EditPost.gif) at the bottom of post #1 and add [SOLVED] to the beginning.

Also remember that you can click the Star (Reputation.gif) symbol in the bottom left corner of any and all posts that you considered "helpful".

Enjoy!
K