How to create a scalable method to hide and unhide columns

[dmerlino]

Hello,

This is my first post to this forum, so thank you in advance to all the experts here. I have a prototype that hides and unhides columns in my spreadsheet based on inputs. However, I expect the combinations to grow thus requiring me to develop a more scalable solution than the one I have below. Any assistance is greatly appreciated. My current code is listed below.

Please Login or Register  to view this content.

[rylo]

Hi

1) How would you determine the outermost column to include in the range? At the moment, you have column O, but if you have other options, would you have more columns?
2) What determines which column is to be unhidden? Is there something in the column that relates to the 2 inputs so that it can be determined from those inputs?

rylo

[dmerlino]

Hello Rylo,

Thank you for the reply.

1) Yes, I would have more columns, and they will be fixed, to correspond the input. There could be many columns At least that the current model unless there is a better way to manage.

2) The determining factor of which column is to be unhidden is the combination of two inputs which I then manually correspond to the appropriate column header, thus determining the Excel column ID. Currently there is no intelligence built into the column header naming vs the inputs. If there is a method to handle the VBA code to link the inputs to column title, then maybe that would help.

Thank you for your assistance,

Domenico

Hi

1) How would you determine the outermost column to include in the range? At the moment, you have column O, but if you have other options, would you have more columns?
2) What determines which column is to be unhidden? Is there something in the column that relates to the 2 inputs so that it can be determined from those inputs?

rylo

[rylo]

Hi

Can you generate an example file for this with realistic, but not sensitive data?

rylo

[dmerlino]

Hi,

I have attached a sample called sample.xls.

Thank you,

Domenico