Need help using Cell contents for Range of Rows to be Hidden - Would INDIRECT work?

Is there anything unique about the starting and ending rows for those ranges? If so you could have them dynamically created using a match function.

Hi Kelley,

The rows are just products that we provide for use in our Quote tool and based on the drop-down, I want to hide the rows not needed to narrow the tool down a little. It is a little daunting to look through 1500 line items and although you can search for each one, this would save some time.

I am not familiar with the MATCH function in this case. As you can see by the code, there are arrays of rows to hide and when I add three products into the mix, it is not intuitive enough to expand the arrays.

Oh well, if you have an example of the MATCH function in light of this issue, I would welcome it.

Thank you for your response.

With best regards,
Rick

I would suggest naming your ranges, and to make it easy, use VBA to do it. Copy and paste the following into a code module(replace Sheet1 with your sheet name):

Please Login or Register  to view this content.

Copy and paste the code line 3 times and adjust the copies for your other three ranges. Then run the code to create the names. Then replace all your code above with:

Please Login or Register  to view this content.

I haven't tested this entirely, but it should be close.

Hi Nate,

I appreciate the code and will try it out. Sometimes I need more eyes on the issue.

Thank you again,
Rick

Hello FDibbins,

I apologize for an incorrect post. I will update the title and it looks like you already edited the code?

Thank you,
Rick

Thank you!

rguliuzza,

Were you able find a solution using NateFarms suggestion? If not then I can spend some more time on it.