Hide on mass - Macro

Hi

Even if you were to select the entirerow you would still have to specify which cell was the activecell so that wouldn't really give you the deisred result.

How about the following. Could you change the "to" value of i to the number of columns that you want to check less 1 (ie if there were 11 columns to check the i=1 to 10). The IF statement uses an else so that you will always move over one column to the right whether the selected column is hidden or not. The FOR...NEXT loop sits outside the IF statement so that you're running the IF statement for each number in the loop.

Please Login or Register  to view this content.

I'm not sure that you'll be looking for the word "Capacity" in each column. If that's the case then you may want to use an array. For example say you wanted to hide the columns that were headed "Capacity","Date" and "Gender";

Please Login or Register  to view this content.

Hope that maybe of some use.

A

The first code worked like a charm! Thanks alot!

The second didnt do anything(With my titles ofc) so I tried the following

Please Login or Register  to view this content.

EDIT : No Luck