how to hide all columns who's header name matches a single column list, in the same sheet.

Hello,
I've got a worksheet with 300+ columns (they are the field names from a database). This sheet is only used to build reference lists from each column. However, to keep the sheet easier to be used, I want to hide the columns that are currently not needed (but I don't want to delete the column). It should be noted that these columns are NOT in one contiguous large group, but are spread out through the whole sheet).

The worksheet is called REFDATASHT as its code name, "REF" as its visible name.
I have Column A in said sheet that is a list of all the columns that I want to hide.

I've thought about populating an array with the list from Col A, and the look through the headers of the entire worksheet, and then hide that column if found.

I'm mostly wondering if someone knows of a more efficient way to do this, here's a pseudo flow of how I'd do this:

Please Login or Register  to view this content.

Id likely set this to run when that sheet is visible or takes focus.

Is there a more efficient way to do this?

Originally Posted by JBeaucaire

This is the version that self-activates, put this in the sheet module:

Please Login or Register  to view this content.

Dude!

This is perfect! Works like a charm!